Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Table has ID column and Final Pause (calculated Column) where same ID can have multiple Final Pause data.
In output ,I need only unique ID's with Final Pause value with highest priroity i.e.
1. Pause
2. No Pause
3. Unmatched
So if ID has Pause, No PAuse & Unmatched , output should have Pause only for that ID as it has highest priority
but ID has No Pause & Unmatched then o/p should have No Pause against ID as its highest among (No Pause & Unmatched)
Input table:
UID | Final Pause |
W0234821-21/07/2021 | No Pause |
W0234821-21/07/2021 | Pause |
0092509-14/07/2021 | Unmatched |
0092509-14/07/2021 | Pause |
0092509-14/07/2021 | No Pause |
2192509-14/07/2021 | Unmatched |
2192509-14/07/2021 | No Pause |
2192511-14/07/2021 | Unmatched |
Output Table:
UID | Final Pause |
W0234821-21/07/2021 | Pause |
0092509-14/07/2021 | Pause |
2192509-14/07/2021 | No Pause |
2192511-14/07/2021 | Unmatched |
Hi @Raj12 ,
I have created a simple sample, please refer to my pbix file to see if it helps you.
How to Get Your Question Answered Quickly - Microsoft Fabric Community
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi! In Power Query, assign a value to your priority, then sort by the priority and remove duplicates on the UID.
Proud to be a Super User! | |
Hi,
Column shown above is a measure created in Power Bi and hence can't work on it in Power Query.
Thanks
I'm sorry, I thought you said UID and Final Pause were from your input table/source. My suggestion was that you then assign the priority numbers to the values in Final Pause in Power Query, then sort those in ascending order, then remove dupliates on your UID.
Proud to be a Super User! | |
Final Pause is a measure calculated based on differnet other tables and cant be defined in Power Query.
Can we do it in Power Bi itself ?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |