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     🙂

nandukrishnavs's avatar
nandukrishnavs
Icon for Community Champion rankCommunity Champion
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 🙂