Solved: Group by specific condition

HugoCExtA · ‎09-19-2016

Hello,

I have a table that I'd like to group by with a specific condition, the condition is : each time there is a 1 in a colum I'd like to group until there is another 1 in the same column. (Not sure it is very clear so I made a picture of what I'd like).

I'm not even sure it is possible with Power BI, but still any advice would be nice.

Thanks in advance.

ImkeF · ‎09-19-2016

In the query editor just add an index column first. Then multiply that with Type. Replace 0 by null and fill down values.

That will allocate the same number to each row in the group but a different number per group.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

ImkeF · ‎09-19-2016

In the query editor just add an index column first. Then multiply that with Type. Replace 0 by null and fill down values.

That will allocate the same number to each row in the group but a different number per group.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

HugoCExtA · ‎09-19-2016

Thanks, it worked ! Did not know the fill function 🙂

Group by specific condition

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly