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 everyone!
Some time ago I was told to aply this formula to get the accumulated value per month of a column:
AccumPerMonth = Calculate(Sum('table'[column]), Filter(All('table'[month]), table'[month]<=MAX(table'[month])))
Now, I've got 2 columns and a measure.
This measure gets the diference between those 2 tables.
So when I try to use the formular I've put before, I can't use the measure in the SUM statement.
Any idea why?
Kind regards
Solved! Go to Solution.
Hi @chrisgehm,
>>Now, I've got 2 columns and a measure. This measure gets the diference between those 2 tables.So when I try to use the formular I've put before, I can't use the measure in the SUM statement.
You have two tables, if there is relationship between them? And what are your two columns? Is there any chance to share your sample data for further analysis? I am unable to reproduce your scenario based on your description.
And why do not you use the formula? Could you please share your error message?
Best Regards,
Angelia
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 |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |