Forum Discussion

Robin96's avatar
Robin96
Icon for Helper II rankHelper II
2 years ago

Move values 1 week ahead

Hey guys, i have some trouble moving my original values 1 week ahead. Anyone have an easy DAX calculation for this? This is my desired outcome:   I have tried this measure, but its not giv...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Does this measure work?

=CALCULATE([Totals Lines | Cash balance],datesbetween('Dimension Date'[date],min('Dimension Date'[date])-7,min('Dimension Date'[date])-1))