Previous Month Sales with Month Selected in Slicer

[Sid8686]

Hi All,

I got stuck with a DAX measure.

I need to calculate the Current Month's sales and the Previous Month's sales. Both the measures are working perfectly if nothing is selected in the date or month slicer. when I select a month in the slicer then the Previous Month's sales measure is giving a blank.

For example, if I select "June" in the slicer table then the Current Month's sales measure should be of June and the Previous Month's sales measure should be of May.

My measure are given below:

Current Month Sales =
TOTALMTD (
SUM ( 'Dataset supply chain'[total sale] ),
DATESMTD ( 'Dataset supply chain'[Order date] ))

Previous Month Sales =
CALCULATE (
SUM ( 'Dataset supply chain'[total sale] ),
PREVIOUSMONTH ( DATESMTD ( 'Dataset supply chain'[Order date] ) ))

I am also attaching screenshots of the results.

Looking forward to a solution.

Thanks,

Sid

[Sid8686]

Multiple columns cannot be converted to a scalar value

[Sid8686]

Thanks, it works.
One more question regarding the same visual. how i can calculate the TOP 5 products (by sales) of the Current Month and the Top 5 products (by sales) of the Previous Month? I am trying the above measures with the TOPN function but it is giving me error.

[Sid8686]

Please do let me know if anyone here helps me how to solve this

[Sid8686]

Hello , any solution for this query?

[johnt75]

What is the error message ?

[johnt75]

Firstly, create a proper date table and link it to your fact table. Then you can create measures like 

Current Month Sales =
TOTALMTD ( SUM ( 'Dataset supply chain'[total sale] ), 'Date'[Date] )

Previous Month Sales =
CALCULATE (
    SUM ( 'Dataset supply chain'[total sale] ),
    PREVIOUSMONTH ( 'Date'[Date] )
)