mahmed1
Well-known Member
- Joined
- Mar 28, 2009
- Messages
- 2,302
- Office Version
- 365
- 2016
- Platform
- Windows
Hi All
How do i calculate Fiscal QTD in power BI? My Financial year starts at 01.04
I am able to do it with YTD using this = Calculate([Total_Time],DatesYTD[Calender_Lookup_Dates[Dates],"31/03"))
Now I wan to do same thing but for the Quarter but the latter option is not avaliable
I do have a Fiscal Year column that stores in this format - FY20, FY21 etc
Fiscal Quarter in this format - FQ1, FQ2, FQ3 and FQ4
and Fiscal Period which is running from 01/04/2017 from my calender table
What do i need to add to get QTD by fiscal quarter?
Thank YOU
How do i calculate Fiscal QTD in power BI? My Financial year starts at 01.04
I am able to do it with YTD using this = Calculate([Total_Time],DatesYTD[Calender_Lookup_Dates[Dates],"31/03"))
Now I wan to do same thing but for the Quarter but the latter option is not avaliable
I do have a Fiscal Year column that stores in this format - FY20, FY21 etc
Fiscal Quarter in this format - FQ1, FQ2, FQ3 and FQ4
and Fiscal Period which is running from 01/04/2017 from my calender table
What do i need to add to get QTD by fiscal quarter?
Thank YOU