Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lavdeepk
Resolver I
Resolver I

How to calculate Indian fiscal year and quarter ?

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.