Forum Discussion
PowerQuery M Min/Max Contiguous ID Values by Group
Disregard , I finally found a solution at the link below. A huge thank you to edhans whose solution there was more than sufficient for me to figure it out. I wasn't aware of how to lag a column's values to create the boundaries I was after in M, that was the missing key in my case.
Link to the original thread: https://community.powerbi.com/t5/Power-Query/Grouping-Date-sets-within-a-month/m-p/1428838#M44645
However, if anyone has any alternatives aside from lagging a column and then producing a conditional index that would be great. I'm a bit worried about the efficiency of this method as the data grows (could be unfounded though) and always looking to learn.
Disregard , I finally found a solution at the link below. A huge thank you to edhans whose solution there was more than sufficient for me to figure it out. I wasn't aware of how to lag a column's values to create the boundaries I was after in M, that was the missing key in my case.
Link to the original thread: https://community.powerbi.com/t5/Power-Query/Grouping-Date-sets-within-a-month/m-p/1428838#M44645
However, if anyone has any alternatives aside from lagging a column and then producing a conditional index that would be great. I'm a bit worried about the efficiency of this method as the data grows (could be unfounded though) and always looking to learn.