Excel BI Power Query Challenge Workout 058

-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 58-
(Solution in any language also welcome for Power Query Challenges)

Starting opening balance (OB) = 100 (This is given and you will need to work out OB for Serials 2 through 9)

  • Hence, Serial no. 1 OB = 100
  • Serial no. 2 OB = 1000+100 = 1100
  • Serial no. 3 OB = 1100+500 = 1600
  • Serial no. 4 OB =1600-400 = 1200
  • …and so on

Find the Min opening balance for every day.

Download Practice File - https://lnkd.in/d-Vmh685

(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’s LinkedIn Post