Forum Discussion

hhebbalu's avatar
hhebbalu
Frequent Visitor
5 years ago
Solved

Time Intelligence Functions with Fiscal Calendar

Hi,

 

We have Fiscal Dates in the Date table in our database and also marked the table as Date table in Power BI. We use Fiscal dates to calculate measures. The Time Intelligence functions like TotalMTD, TotalQTD, TotalYTD are not working with the fiscal Dates and trying to use Calendar Dates. We did find few examples where there is a filter at the end which has end of the year in the format "mm-dd". But that is not something we want to do. We went ahead and created the measures writing custom DAX queries. But we wanted to confirm in the Power BI community that it is not possible to use TIme Intelligence with the fiscal Calendar dates.