Forum Discussion

powerbiss's avatar
powerbiss
Helper I
4 years ago
Solved

Dynamic Monthly Sales

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...
Need Help
TomMartens's avatar
TomMartens
Super User
4 years ago

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.