Forum Discussion
Filtered Calculation
Hi,
I need to create a new calculation for my table to remove the values prior to current month.
The calculation will need to be something like this but not too sure on the correct syntax.
Calculate(
sum(apps[app_amount),
Apps[info] in {"test","live"}
&& month_index[month] less than month (today()), 0 else apps[app_amount])
Sorry I was a little fast it need to be sum(apps[app_amount])))
5 Replies
Try this
Name =Calculate(sum(apps[app_amount),
if(SELECTEDVALUE(
Apps[info]) in {"test","live"} &&
SELECTEDVALUE(
month_index[month]) < today(),
0,
apps[app_amount]))Thanks for the suggestion but unfortunately, the final part of the logic "apps[app_amount]))" isn't being accepted. I just have the red line underneath.
Sorry I was a little fast it need to be sum(apps[app_amount])))
It could make sense to add a column to your model's Date or Month table to show a value [Months From Current], where all dates within the current month have a value zero (0), and the prior month has value -1, two months prior -2, etc. Next month would have a value +1, two months into the future +2, etc. This would allow you to expand your queries to show "n months from current" or allow users to filter their choice of months from current. Plus, the DAX could be simplified.
