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"
Solved! Go to Solution.
you can do this in a few steps:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
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"
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"
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!