How to write condition in power query to check multiple rows

[Quinn]

Like below table, if same PO has 2 lines , i want to check if the value in "Plant" column. If it is same, than add a new column to result "Same Plant", if it's different, then result " Multiple Plant".

For example: PO 510161981 should be "Same Plant"

PO510011416 and 510081262 should be "Multiple Plant"

[Ahmedx · Accepted solution]

see me video
How to write condition.mp4
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rh0HdYsuuz8d8xhnU?e=zXb8Vx

[Ahmedx]

sorry, need to group by two columns [Po] and [Plant]
I fixed my mistake, you can watch my video again

[Quinn]

Hi,
I followed your PBIX file and can get the right result!

[Ahmedx]

If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.

[DOLEARY85]

Hi,

you can do this in a few steps:

1. Group By on PO & Plant, adding a count rows aggregation and the data for all other columns in all rows to be expanded later:
2. Add a custom column for if the count rows field is greater than 1 same plant else multiple plant:              if [Count] > 1 then "Same Plant" else "Multiple Plant"
3. Expand the data rows to get any other data back
4. remove the count rows column:

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[Quinn]

I have followed by tyour steps, but there's something wrong, and some times the same PO may have 4 lines, I need result to indicate this PO has "Multiple Plant"

[Ahmedx]

show how the result should be
and how to understand result "Multiple Plant".

[Quinn]

PO 512161981 have 2 lines and both Plant is "PlantMY", then result should be "Same Plant",
if same PO have 2 or 3 lines, Plant has "PlantMY" and "Plant00", then the result should be "Multiple Plant"