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.
Hi I am doing a Balance Sheet and i want a running total to reset. I cannot get the running total to reset at Capital and Reserves
Below are some columns that I created to identify where to reset. When calcType changes, the running total should reset.
I cannot get my brain around to write this DAX code 🤔
Solved! Go to Solution.
I am closing this one. I figured it out eventually! Running totals cannot be reset in the same column. I had to do another running total column and use SWITCH to get the best of the two columns.
I am closing this one. I figured it out eventually! Running totals cannot be reset in the same column. I had to do another running total column and use SWITCH to get the best of the two columns.
User | Count |
---|---|
65 | |
46 | |
20 | |
18 | |
15 |
User | Count |
---|---|
120 | |
41 | |
40 | |
28 | |
23 |