The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |