I followed the excellent Semi Additive mesure guide at sqlbi.com (https://www.sqlbi.com/articles/semi-additive-measures-in-dax/) and now have a report that tracks balences accurately and the measure reports the most recent balance of the quarter.
LastBalance Ever :=VAR MaxDate =MAX ( 'Date'[Date] )VAR LastDates =ADDCOLUMNS (CALCULATETABLE (VALUES ( Balances[Name] ),ALL ( 'Date' )),"LastDay", CALCULATE (MAX ( 'Balances'[Date] ),ALL ( 'Date' ),'Date'[Date] <= MaxDate))VAR LastDatesWithLineage =TREATAS (LastDates,Balances[Name],'Date'[Date])VAR Result =CALCULATE (SUM ( Balances[Balance] ),LastDatesWithLineage)RETURNResult
I'm now keen to understand how I would compare changes between the most recent balence and the previous most recent balence. For example;
Is there a DAX command that would allow me to compare with the previous last balence? Any ideas on how I could approach this?
Go to Solution.
@Douglas_M Please refer to my measure for this sample data:
Paul Zheng _ Community Support TeamIf this post helps, please Accept it as the solution to help the other members find it more quickly.
View solution in original post
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.