Skip to main content
Microsoft Idea

Power BI

Needs Votes

Time Intelligence - Allow General References in Date Table to Report MTD, QTD, YTD

Vote (11) Share
Scott Ferguson's profile image

Scott Ferguson on 15 May 2017 09:19:57

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.