-CAN YOU SOLVE THIS - POWER QUERY CHALLENGE 50-
(Solution in any language also welcome for Power Query Challenges)
If there is a discontinuity in dates for a Store, fill in the missing dates with details of previous records and also fill in the sequence of record numbers for a customer in that store.
Hence row 2 has date of 5/1/22 and row 3 has date of 5/3/22 for Store A. Hence, row 2 will be repeated with the date of 5/2/22 and sequence numbers for these will be 1 & 2.
For Russell, the sequence number will be 1 as sequence number is for a Store & Customer.
Download Practice File - https://lnkd.in/dVCD4wyq
(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