Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |