Forum Discussion
M_SBS_6
Helper V
Helper VFiltered 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. ...
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.