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"
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.