Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
So generally you could do something like:
EUR Total - Actual =
VAR __myCalc =
CALCULATE (
SUM ( [EUR Equiv] ),
FILTER (
ALLselected ( 'Calendar'[Year/Month] ),
'Calendar'[Year/Month] <= MAX ( 'Calendar'[Year/Month] )
),'Budget Actual'[Budget,Actual]="Actual"
)
RETURN
IF(MAX('Calendar'[Date])>NOW(),BLANK(),__myCalc)
Try replace 'Calendar'[Year/Month] <= MAX ( 'Calendar'[Year/Month] ) to 'Calendar'[Year/Month] <=NOW()
EUR Total - Actual =
CALCULATE (
SUM ( [EUR Equiv] ),
FILTER (
ALLselected ( 'Calendar'[Year/Month] ),
'Calendar'[Year/Month] <=NOW()
),'Budget Actual'[Budget,Actual]="Actual"
)
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Try replace 'Calendar'[Year/Month] <= MAX ( 'Calendar'[Year/Month] ) to 'Calendar'[Year/Month] <=NOW()
EUR Total - Actual =
CALCULATE (
SUM ( [EUR Equiv] ),
FILTER (
ALLselected ( 'Calendar'[Year/Month] ),
'Calendar'[Year/Month] <=NOW()
),'Budget Actual'[Budget,Actual]="Actual"
)
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
So generally you could do something like:
EUR Total - Actual =
VAR __myCalc =
CALCULATE (
SUM ( [EUR Equiv] ),
FILTER (
ALLselected ( 'Calendar'[Year/Month] ),
'Calendar'[Year/Month] <= MAX ( 'Calendar'[Year/Month] )
),'Budget Actual'[Budget,Actual]="Actual"
)
RETURN
IF(MAX('Calendar'[Date])>NOW(),BLANK(),__myCalc)
User | Count |
---|---|
98 | |
90 | |
78 | |
71 | |
64 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |