Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to Solution.
Hi,
That formula needs to be a measure, not a calculated column formula.
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
Hi,
That formula needs to be a measure, not a calculated column formula.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
86 | |
78 | |
66 |
User | Count |
---|---|
151 | |
121 | |
111 | |
107 | |
95 |