Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi guys,
I am trying to compute current month sales, and also get the last two previous months. Is it possible to show the months change dynamically. Example if this Feb 2022. then cards should show Feb-2022, Jan-2022, and Dec-2021. Sorry I couldnt find how to attach the excel file with the data. See below screenshot for the desired output. Thanks for all your help. Really appreciate it.
Solved! Go to Solution.
Hi, @powerbiss
Please check this example:
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
Proud to be a Super User!
pls see the attachment below
Proud to be a Super User!
pls see the attachment below
Proud to be a Super User!
Hey Ryan,
This is awesome. Have been struggling to get the previous months data and the title
Really appreciate your help.
you are welcome
Proud to be a Super User!
Hi, @powerbiss
Please check this example:
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
Proud to be a Super User!
Hey @powerbiss ,
this article contains almost everything you need to tackle your challenge: https://www.daxpatterns.com/time-patterns/
First create a calendar table and relate the table with your date column.
Then create three measures calculate the sales, the first is filtered by the max available month, the 2nd is filtered by the max available month - 1
Hopefully, this provids what you are looking for.
Regards,
Tom
P.S.: The ideal way to share your data, is uploading the pbix file to onedrive or dropbox and share the linkl. If you are using Excel to create the sample data instead of the manual input method, share the xlsx as well.