Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I've a dataset which gets monthly sales data for entities A,B & C. Data is not regular and comes consolidated only after few months so currently we have data up to June-22. Objective is to show Sales for Latest Month, Last Month & Same Month Last year from dataset.
something like this
Now i'm able to calculate latest sales i.e for June-22 using a measure with max filter on date column.
however i'm not sure how to do this for previous month and also same month last year. it also needs to be taken into consideration for when year will change. there are to be no date filters on the report page.
Sample Data:-
@amitchandak @parry2k @Greg_Deckler
Solved! Go to Solution.
Hi,
I am not sure how your data model looks like, but I tried to create a sample pbx file like the attached.
Please check the attached file.
All measures are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@UmangPaliwal check these 2 videos on my YT channel and tweak it as you see fit
Learn how to compare MTD sales as of date with same number of days last year - Part 7 - YouTube
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi,
I am not sure how your data model looks like, but I tried to create a sample pbx file like the attached.
Please check the attached file.
All measures are in the attached pbix file.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you. this works just fine
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
98 | |
80 | |
76 | |
66 |
User | Count |
---|---|
135 | |
109 | |
104 | |
83 | |
73 |