Forum Discussion
Solved
Waterfall Chart- MTD Comparison
Hi All, Need some help with my waterfall chart. As a novice in Power BI, I've been trying to bring myself up to speed via reading different tutorials and YT resources followed by lots of practice...
Hi Oharoonchipz ,
You can change dax to the following form:
CM Data Traffic = VAR _lastActualValue = MAX ( Traffic[Date] ) RETURN IF ( SELECTEDVALUE ( Dates[Date] ) <= _lastActualValue, CALCULATE ( 'Data Traffic Measures'[Daily Avg Data Traffic], FILTER ( ALL ( Dates ), Dates[Date] >= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) ) && Dates[Date] <= TODAY () ) ) )If I have misunderstood your meaning, please provide your desired output and your pbix file without privacy information.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Oharoonchipz ,
You can change dax to the following form:
CM Data Traffic =
VAR _lastActualValue =
MAX ( Traffic[Date] )
RETURN
IF (
SELECTEDVALUE ( Dates[Date] ) <= _lastActualValue,
CALCULATE (
'Data Traffic Measures'[Daily Avg Data Traffic],
FILTER (
ALL ( Dates ),
Dates[Date]
>= DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, DAY ( TODAY () ) )
&& Dates[Date] <= TODAY ()
)
)
)If I have misunderstood your meaning, please provide your desired output and your pbix file without privacy information.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.