Dynamic Monthly Sales

[powerbiss]

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.

[ALLUREAN · Accepted solution]

Hi, @powerbiss 

Please check this example:

https://www.dropbox.com/s/rgbhppu8b3x13r5/Dynamic%20Monthly%20Sales%28allure-analytics.com%29.pbix?d...

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

[ryan_mayu · Accepted solution]

@powerbiss 

pls see the attachment below

[powerbiss]

Hey Ryan,

This is awesome. Have been struggling to get the previous months data and the title

Really appreciate your help.

[ryan_mayu]

you are welcome

[ALLUREAN · Accepted solution]

Hi, @powerbiss 

Please check this example:

https://www.dropbox.com/s/rgbhppu8b3x13r5/Dynamic%20Monthly%20Sales%28allure-analytics.com%29.pbix?d...

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

[TomMartens]

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.