Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Wondering anyone can help me here please?
I am looking generate final status column based PO status and ID. If all PO status is Yes then final status will be Yes, all PO status is No then final status will be No PO, if mixed then returned as Partial for those ID. My PO status column is calulated column based on PO ref using power query.
Thanks
Hi @saukulkarni22 ,
Please use the below calculated column,
Hi,
Thanks for reply. But forgot to mention I am using direct query and calculate is not supported in direct query for calculated column DAX expression.
I recommanded to bring this summerize status in a separate table with the ID column
ID | Final status |
1 | YES |
2 | Partial |
3 | NO PO |
Proud to be a Super User!
Hi,
This could work. Could you provide more details on this.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |