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 Usershow how the result should be
and how to understand result "Multiple Plant".