I have a date table which has fiscal Year starting from July and ending on June.
I have to perform below calculations based on fiscal date range.
1. Current fiscal month sales ( which is march 2023 , and comes under FY23)
2.Previous fiscal month sales(feb 2023,FY23)
3.Current fiscal Quarter sales(Q3, since jan -mar is Q3 for Fiscal Year starting on July)
4.Previous fiscal Quarter sales(Q2 , which is oct-dec)
3.Current Fiscal Year sales (FY 23 , which is July 1 2022- June 30 2023)
6.Previous Fiscal Year sales(FY22 , which is July 1 2021-June 30 2022)
Sample dax : Sales = sum(sales)
Note: I tried month(Today()) but its showing as 3 since its taking calendar from Jan.
Can someone please help here.
Share the download link of the PBI file.
Hi @Ashish_Mathur ,
attaching link for sample pbix with date and sales table.
I cannot open the file. This is the message i get
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.