Regarding Sales LYTD Measure

[Sai_Kumar]

Hey,

Hello Everyone, 

I am looking for a measure to calculate the sales Last Year to date (The requirement was it needs to calculate the last year sales up to the current Month last year)

The below image gives a brief idea.

If you see the FY22, Sales AUD was the current running sales and 000Sales LYTD was last year(FY21) sales. I got the data that I am looking for but if you see the total it was showing total sales for (FY21).
(If the total adds the above 2 months for 000 Sales LYTD then the problem was solved).

The current Measures I am using was 

Sales AUD was Total sales 

000 Sales LYTD = if([SalesAUD], CALCULATE([SalesAUD], DATEADD('Master Calendar'[Date],-1,YEAR)))

Thanks guys, 

Looking forward to hear from you.

[Tanushree_Kapse]

Hi @Sai_Kumar ,

Use this measure in the values field to get the correct total:

Totalfixed= SUMX(VALUES( Fiscal Year Fiscal Month) , 000 Sales LYTD)

I hope this helps!

Mark this as a solution if I answered your question. Kudos are always appreciated.

Thanks!