Using month name instead of month number

[AishwariyaV]

Hi all,

In my report, i have calculated 

Previous month sales = CALCULATE(SUM(Order_Details[Sales]),FILTER(ALL(Order_Details[Month num]),Order_Details[Month num]=MAX(Order_Details[Month num])-1))
Current month sales = CALCULATE(SUM(Order_Details[Sales]),FILTER(ALL(Order_Details[Month num]),Order_Details[Month num]=MAX(Order_Details[Month num]))).
I have included a table visual for these sales.

When i am using Month name as slicer and if i select one month name, the previous month sales is not appearing. Only when i select two month names, i am getting the previous month sales. This is one scenario.

When i am using Month num as slicer and if i select one month num, i am getting the previous month sales.

In my case, i need month name as slicer and if i select one month name, the previous month sales should appear in the table.

I couldn't use Month name in the DAX formula

[mussaenda]

Or you can transform your date in query editor and extract moonth number and month name and use your extracted month num to code and usethe extracted month as slicer.

[AishwariyaV]

I have added the Month name and month num by extracting from date. 

[mussaenda]

Using Query Editor? If so, please share a pbix to reproduce the issue

[AishwariyaV]

https://1drv.ms/u/s!AiOYNUHREfJzgj3jm3_NVkGH3NPJ

[mussaenda · Accepted solution]

It doesn't show the previous month because we did not specify the year.

Please see attached pbix

pbix

[mussaenda]

Please share PBIX file. If your data is confidential, pls provide a dummy

[Vikram123]

can you share PBIX File