-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 12-
(Excel formulas also welcome)
If there is a sequence missing for a given ID, fill in the missing sequence and repeat the row above for all other columns.
For 456, 4 and 6 are missing. Hence 4 is repeated with sequence 3 information and 6 is repeated with sequence 5 information.
For 890, 3 & 4 are missing, hence 3 & 4 are repeated with sequence 2 information.
Download Practice File - https://lnkd.in/dsABE6Tb
(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