Financial Period over Period

[Iwona]

I am trying to create KPI for my complaints and have to display Total Complaints Financial Period over Financial Period. I can’t use typical time intelligence functions because they refer to Gregorian Calendar only. Does anyone know how to do it ?
Complaints - forum.pbix (104.5 KB)

Could I please ask for help.

Many thanks,

[Heather]

Some great resources were brought together on this post regarding non-calendar table functions:

Non-Standard Time Intelligence

The available DAX date intelligence functions in Power BI handle the comparison with previous periods easily for the standard periods of year, quarter, month, and day when using a standard calendar, or a standard fiscal calendar (where quarters start on a 3-month cadence, e.g., April 1, July 1, etc., and aligned to [but offset from] calendar quarters). These functions do not, however, handle weekly comparisons or custom fiscal calendars. Calculation techniques to handle week comparisons and non-…

[Iwona]

Hi @Heather

Thank you very much , Thanks to your cheat sheet, I managed to complete my task.

Regards,

Iwona