Fiscal QTD

[Helal123]

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

 

[Chihiro]

I assume you have Date dimension table with appropriate fields?

You need to calculate MAX of Fact[Date] column, when filtered when Dimension[Quarter] is filtered for specific quarter.

Same concept as the post I made in link below.
Calculating Sales By Period to Date in Power BI | Chandoo.org Excel Forums - Become Awesome in Excel

If you need further help. I'd recommend uploading sample workbook that shows what tables you are using, specifying which column(s) relate with each other.