9
It seems that quick measures for MTD, QTD, YTD will not display results in tables, or charts if the related date elements are not included in the values. For example, including only the Month in a matrix will display blanks for the quick measure: Sales YTD = IF(ISFILTERED('Calendar'[Date]), ERROR("Time intelligence quick measures can only be grouped or filtered by the Power BI-provided date hierarchy."),TOTALYTD('Sales'[Sales], 'Calendar'[Date].[Date])).
However, the same date values will display results for the formula: Current YTD (Manual) = CALCULATE(Sales[Sales],DATESYTD('Calendar'[Date])).
The time intelligence quick measures should be more flexible in how they are reported.
STATUS DETAILS
Needs Votes