Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good day everyone,
I am struggling to calculate the running total for the total #Tasks for the article ID,
This is my Summarize table in PowerBI:
I want to calculate the cumulative #Tasks like below:
Any help would really be appreciated please
Solved! Go to Solution.
@AnnaSA ,
New column
cumm = sumx(filter(table, [#tasks] <=earlier([#tasks])),[#tasks])
new measure
cumm = sumx(filter(table, [#tasks] <=max([#tasks])),[#tasks])
@AnnaSA ,
New column
cumm = sumx(filter(table, [#tasks] <=earlier([#tasks])),[#tasks])
new measure
cumm = sumx(filter(table, [#tasks] <=max([#tasks])),[#tasks])
Thank you sooooo much, it worked
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |