Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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])
Solved! Go to Solution.
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.
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])))
Thanks for your help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |