Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
79 | |
61 | |
60 | |
58 |
User | Count |
---|---|
151 | |
113 | |
99 | |
80 | |
72 |