Solved: Assign Sequence to a Date Group List

Syndicate_Admin · ‎05-21-2023

Hello!! I am venturing into PBI and I would like to know how to solve a sequence assignment to a group of dates of which one or more are repeated.

Original Table

Reaching this result

Please appreciate a helping hand!!!

Carola!!!!

Ritaf1983 · ‎05-21-2023

Hi,

Please refer to the tutorial for the steps that you need to do in PQ :
https://excelguru.ca/number-rows-by-group-using-power-query/
If my answer was helpful please give me a Kudos and accept as a Solution.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Ritaf1983 · ‎05-21-2023

Hi,

Please refer to the tutorial for the steps that you need to do in PQ :
https://excelguru.ca/number-rows-by-group-using-power-query/
If my answer was helpful please give me a Kudos and accept as a Solution.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Assign Sequence to a Date Group List