Forum Discussion
YTD Measure
How to change "Actual YTD" line to only shows Actual period ?
Or which chart should be used to represent this YTD ?
I have used this measure :
Revenue YTD =
IF(
ISFILTERED('Calendar'[Date]),
ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy or primary date column."),
TOTALYTD(SUM('Data'[Amount]), 'Calendar'[Date].[Date])
)
1 Reply
If you want to suppress the line for future months add a logic that returns BLANK() in these cases.
