Calculate number of days in fiscal quarter

[amrmatar]

Appreciate if you can help me calculate the number of days in a fiscal year that starts from the first of April.

I tried using STARTOFQUARTER and ENDOFQUARTER functions to count the number of days between the end and the start of the quarter; but these functions work properly in a regular calendar, not the fiscal calendar.

[amitchandak]

@amrmatar , I have discussed approach to deal with these

https://medium.com/chandakamit/cheat-sheet-calendar-of-any-standard-month-just-one-variable-apart-5e...

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

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