Previousmonth calculation showing blank

[HusseinKhalil]

Hi,

i am using the below for previousmonth calculation, but result is always blank.

Syntax: 

PreviousMonth = CALCULATE(SUM('Monthly Speed - All Operators b'[Download Speed Mbps]),PREVIOUSMONTH('Monthly Speed - All Operators b'[Aggregate Date]))

sample for the dataset in the below link

https://www.dropbox.com/scl/fi/gzvlsa1tno4ijbwohpl0i/Sample-for-PreviousMonth.xlsx?dl=0&rlkey=nzon3h...

[nandukrishnavs]

@HusseinKhalil 

This is because of the date hierarchy. 

PreviousMonth =
CALCULATE (
    SUM ( 'Monthly Speed - All Operators b'[Download Speed Mbps] ),
    PREVIOUSMONTH ( 'Monthly Speed - All Operators b'[Aggregate Date].[Date] )
)

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[HusseinKhalil]

thanks you nandu, but it worked now, but i noticed that aggregate date format inside matrix changed.= and not showing year/month any more. 

is there a way to handle this and keep the format as it is?

[amitchandak]

@HusseinKhalil , best way is use date table for this

PreviousMonth = CALCULATE(SUM('Monthly Speed - All Operators b'[Download Speed Mbps]),PREVIOUSMONTH('Date'[Date]))

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

[nandukrishnavs]

@HusseinKhalil  - Yes I have modified the above reply. Please check that.

[nandukrishnavs · Accepted solution]

@HusseinKhalil 

PreviousMonth =
CALCULATE (
    SUM ( 'Monthly Speed - All Operators b'[Download Speed Mbps] ),
    PREVIOUSMONTH ( 'Monthly Speed - All Operators b'[Aggregate Date].[Date] )
)

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂