-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 71-
(Solution in any language also welcome for Power Query Challenges)
Find the running total for the groups. The running total will be capped at 100 and remainder will be carried forward.
Hence, in row 4, 88+34 = 122. Hence, 22 will be carried forward. Hence, running total in row 5 will be 18+22 = 40
Download Practice File - https://lnkd.in/dUA2XVZ7
(Post answers in Comment. Your approach need not be different from others as long as you have worked out your approach independently)
#powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #excel, #excelchallenge, #python, #r
Excel BI LinkedIn Post: