Help needed with DAX. Unable to get values for previous month.

[Anonymous]

Hello Experts,

I am unable to get the values for Previous month even after using the function. I even tried the function over ALL(dataset), still the desired result is not obtained.

Kindly help.

Here is the pbix file.

[CNENFRNL · Accepted solution]

Last Months Sales = 
CALCULATE (
    [Total Sales],
    PREVIOUSMONTH ( SalesByDate[Date] ),
    ALLEXCEPT ( SalesByDate, SalesByDate[Date] )
)

[Anonymous · Accepted solution]

Hi @Anonymous ,

Below two measure work fine , please try:

Last Months Sales 1 = CALCULATE([Total Sales],PREVIOUSMONTH('SalesByDate'[Date].[Date]))

Last Months Sales 2 = CALCULATE([Total Sales],PARALLELPERIOD('SalesByDate'[Date].[Date],-1,MONTH ))

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CNENFRNL · Accepted solution]

Last Months Sales = 
CALCULATE (
    [Total Sales],
    PREVIOUSMONTH ( SalesByDate[Date] ),
    ALLEXCEPT ( SalesByDate, SalesByDate[Date] )
)