Forum Discussion
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?
Hi,
That formula needs to be a measure, not a calculated column formula.
2 Replies
- Ashish_MathurSuper User
Hi,
That formula needs to be a measure, not a calculated column formula.
- v-piga-msftResident 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