Forum Discussion
How to write condition in power query to check multiple rows
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"
see me video
How to write condition.mp4
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rh0HdYsuuz8d8xhnU?e=zXb8Vx
8 Replies
- DOLEARY85
Resident Rockstar
Hi,
you can do this in a few steps:
- Group By on PO & Plant, adding a count rows aggregation and the data for all other columns in all rows to be expanded later:
- 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"
- Expand the data rows to get any other data back
- remove the count rows column:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
- Group By on PO & Plant, adding a count rows aggregation and the data for all other columns in all rows to be expanded later:
- Ahmedx
Super User
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
- Ahmedx
show how the result should be
and how to understand result "Multiple Plant".
