Forum Discussion
Solved
Difference between Column values in a Matrix
Hi, I have a simple table with a date where the user will be able to select 2 dates and see the difference in Sum of Sales value between the selected dates as shown in the screen shot below. Use...
Diff measure : =
VAR _mindate =
CALCULATE ( MIN ( pbitest[rep_date] ), REMOVEFILTERS ( pbitest ) )
VAR _maxdate =
CALCULATE ( MAX ( pbitest[rep_date] ), REMOVEFILTERS ( pbitest ) )
VAR _diff =
CALCULATE ( SUM ( pbitest[atr] ), pbitest[rep_date] = _mindate )
- CALCULATE ( SUM ( pbitest[atr] ), pbitest[rep_date] = _maxdate )
RETURN
IF ( HASONEVALUE ( pbitest[rep_date] ), SUM ( pbitest[atr] ), _diff )