-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 13-
(Excel formulas also welcome)
Calculate Running Total within Groups.
If Running total becomes negative, then that must be reset to 0 (cases highlighted)
Note - Cell B11 is -31 which is corrected in Excel (Picture can’t be reposted in Linkedin)
Download Practice File - https://lnkd.in/dpJuMjAC
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerbi, #powerquery, #dax, #powerquerychallenge, #powerbichallenge, #powerqueryproblem, #powerbideveloper, #powerbidesktop, #powerbitips, #powerbitricks, #excel, #excelchallenge, #excelproblem, #powerpivot
Excel Bi’s LinkedIn Post