Forum Discussion

HusseinKhalil's avatar
HusseinKhalil
Icon for Helper I rankHelper I
6 years ago
Solved

Previousmonth calculation showing blank

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...
Need Help
  • nandukrishnavs's avatar
    nandukrishnavs
    6 years ago

    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     🙂

HusseinKhalil's avatar
HusseinKhalil
Icon for Helper I rankHelper I
6 years ago

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's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

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/