Forum Discussion

Uka's avatar
Uka
Frequent Visitor
2 years ago
Solved

Calculate the difference in values between previous dates

Hello,   Please can you help me to return the difference between two values within some given dates as below; So, I would like to substract the previous date value from the current one ie ((...
Need Help
  • Uka's avatar
    Uka
    2 years ago

    Hi Greg_Deckler ,

     

    Many thanks for your assistance!

     

    I have now figured it out using the following;

    Weekly Difference =
    Var _selecteddate = VALUES('Date Friday Only'[Date])
    var _maxdate = MAXX(_selecteddate, 'Date Friday Only'[Date])
    var _value2 = CALCULATE([Eng FullTime], 'Date Friday Only'[Date] = _maxdate)
    var _value3 = CALCULATE([Eng FullTime], 'Date Friday Only'[Date] = _maxdate -7)

    Return
    _value2 - _value3

    _value3 has -7 because the dates occur every 7 days, thus returns the date for the previous week
     
    Thanks
Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

Uka Post your sample data as text/table and I'll take a look.

Uka's avatar
Uka
Frequent Visitor
2 years ago

Hi Greg_Deckler ,

 

Many thanks for your assistance!

 

I have now figured it out using the following;

Weekly Difference =
Var _selecteddate = VALUES('Date Friday Only'[Date])
var _maxdate = MAXX(_selecteddate, 'Date Friday Only'[Date])
var _value2 = CALCULATE([Eng FullTime], 'Date Friday Only'[Date] = _maxdate)
var _value3 = CALCULATE([Eng FullTime], 'Date Friday Only'[Date] = _maxdate -7)

Return
_value2 - _value3

_value3 has -7 because the dates occur every 7 days, thus returns the date for the previous week
 
Thanks