How to Get current,previous month ,quarter , Year for fiscal month starting in july for dax

[binayjethwa]

Hi ,

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.

Thanks,

Binay

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[binayjethwa]

Hi @Ashish_Mathur ,

attaching link for sample pbix with date and sales table. 

https://1drv.ms/u/s!AkkYcK56fHUSgnTTMkbJXiXsVc6a?e=ytapI1 

Thanks,

Binay

[Ashish_Mathur]

Hi,

I cannot open the file.  This is the message i get

[Ashish_Mathur]

Hi,

I cannot open the file.  This is the message i get