Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Previous Period Calculation Not Working!

I'm attempting to calculate the previous month's total spent for individual items on a table. The formula I'm currently using to create a new column is:   PreviousTotalSpent = CALCULATE(SUM('Item S...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    That formula needs to be a measure, not a calculated column formula.

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Anonymous,

 

I also agree with  Ashish_Mathu.

 

Please try with create the measure with that formula then you will get the value.

 

Best Regards,

Cherry