Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
@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
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |