Power Query Custom/Conditional Grouping

[wlknsnBI]

Hi,

I'm trying to create a custom [Key] which is used to group items. It's a combination of:

* [Project]

* conditional total where if previous row [Concat] is not same as current row [Concat] add +1

PS: simple grouping of [Project] does not work, because you need to take into account Field 1 & Field 2, if it's filled, the next item should be +1.

Project	Field1	Field2	Index	Concat	Key
A			1	A	A1
A			2	A	A1
A			3	A	A1
B			4	B	B1
B			5	B	B1
B	X	1	6	BX1	B1
B			7	B	B2
B	Y	1	8	BY1	B2
C			9	C	C1
C			10	C	C1
D			11	D	D1
E			12	E	E1
E			13	E	E1
E			14	E	E1

[v-eqin-msft]

Hi @wlknsnBI ,

I have the same doubts as @lbendlin . As you said, as long as one of the following two conditions is met, add 1

•  previous row [Concat] is not same as current row [Concat] 
• Field1 and Field2 are not blank.

So according to my understanding, the row6 should be B2 , row7 =B3, row8=B4

Can you please share more detail information to help us clarify your scenario?

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Why is BY1 not resulting in B3 ?