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...
see me video
How to write condition.mp4
Sample PBIX file attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rh0HdYsuuz8d8xhnU?e=zXb8Vx
Ahmedx
Super User
Super Usersorry, need to group by two columns [Po] and [Plant]
I fixed my mistake, you can watch my video again
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.