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".
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"