-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 26-
(Excel formulas also welcome for Power Query Challenges)
Generate the result table as shown.
The first step of a process should be marked as Start.
The last step of a process should be marked as End.
In between Start and End, steps should be marked as Step1, Step2…
If there is only one step, that should be marked as Start/End
Download Practice File - https://lnkd.in/djfyfBvC
(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
Excel BI’s LinkedIn Post