Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 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 Sales'[Total Spent]),DATEADD('Item Sales'[Date],-1,MONTH))

I've used this formula on a Google Analytics dashboard I created in Power BI and it worked just fine. However, when using it now I'm receiving blank values on my table. I have no idea why this is occuring. I thought maybe it was my column data types that were interfering with the calculation, however when I use SUM on the TotalSpent column, it sums up correctly. DATEADD also works on the date column. It's only when I include both in the calculation formula above that the results do not appear. 

 

Here is what I am seeing:

 

 

Any idea what is going on? 

2 Replies

  • Hi,

     

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

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar

    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