Forum Discussion

Shiqi_C's avatar
Shiqi_C
Frequent Visitor
5 years ago

Month over month calculation blank value

  As the screenshot shown above, the value for the "last" column is blank for each month but yet has value for the quarter. I've included the DAX function for the column. Please help!
Tanushree_Kapse's avatar
Tanushree_Kapse
Icon for Impactful Individual rankImpactful Individual
5 years ago

Hi Shiqi_C ,
Try 
Last= CALCULATE([this],Previousmonth(Table1[date]))

Shiqi_C's avatar
Shiqi_C
Frequent Visitor
5 years ago

Hi,

 

Thanks for your response. The "last" column showed me all blank results even with quarter and year total.