Forum Discussion
LFM
2 years agoHelper III
Finding delta between certain dates while filtering the dates
I want to find the change of values between dates while filtering between dates on the slicer. F.eks I want to choose the dates 01.02.2024 and 15.02.2024 on the slicer and then see the delta value be...
- Anonymous2 years ago
Hi LFM
Please try this:
First of all, I create a set of sample:Then add a measure:
Diff = VAR _currentDate = CALCULATE( MAX('Table'[Date]), ALLSELECTED('Table') ) VAR _previousDate = CALCULATE( MIN('Table'[Date]), ALLSELECTED('Table') ) RETURN CALCULATE( SUM('Table'[Values]), FILTER( ALLSELECTED('Table'), 'Table'[Date] = _currentDate ) ) - CALCULATE( SUM('Table'[Values]), FILTER( ALLSELECTED('Table'), 'Table'[Date] = _previousDate ) )The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
2 years agoNot applicable
Hi LFM
Please try this:
First of all, I create a set of sample:
Then add a measure:
Diff =
VAR _currentDate = CALCULATE(
MAX('Table'[Date]),
ALLSELECTED('Table')
)
VAR _previousDate = CALCULATE(
MIN('Table'[Date]),
ALLSELECTED('Table')
)
RETURN
CALCULATE(
SUM('Table'[Values]),
FILTER(
ALLSELECTED('Table'),
'Table'[Date] = _currentDate
)
) - CALCULATE(
SUM('Table'[Values]),
FILTER(
ALLSELECTED('Table'),
'Table'[Date] = _previousDate
)
)
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.