Update Data in Perpetuity

[nniedzielski]

I am working with sets of data that refresh every week, and I have a variance built into the data to measure open costs:

Open Costs Difference from Previous Week = [Current Open costs]-[Previous Week Open Costs]

But, when the date filter changes, the calculations fail, how can i set up a calculation so that every week when the data is refreshed, PBI will grab this weeks data and last weeks data and do the calculation above?

 

[GraH]

Maybe have a read of this

Week-related calculations – DAX Patterns

www.daxpatterns.com

 

[nniedzielski]

thanks, ill take a read at it