How to calculate Indian fiscal year and quarter ?

[lavdeepk]

Hi Experts,

Need help to create Indian Fiscal year and Fiscal quarter calculated columns.

The Indian fiscal year start from 1 Apr to 31 Mar: For Example FY - 23: 01-Apr-2022 to 31-Mar-2023.

Please help with the DAX formula to create the same.

Thanks

[amitchandak · Accepted solution]

@lavdeepk , hope you need calendar

Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

for

FY Qtr=  if([Qtr]=1, 4, [Qtr] -1)

DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s