Time Intelligence Functions with Fiscal Calendar

[hhebbalu]

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.

[Fowmy · Accepted solution]

@hhebbalu 

It is recommended to use custom calculations when you have fiscal periods. Please refer to this article for more details and guidance :

https://www.daxpatterns.com/custom-time-related-calculations/