The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Thanks guys,
Looking forward to hear from you.
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!
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |