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.
I am trying to use partitions to consolidate the rows in my table into one row.
The data is for candidates who have been referred by multiple people (up to 4). A candidate can have multiple rows containing data as such (there are more columns, however they aren't relevant to this question as they will be the same in all that candidates rows):
As you can see I am able to succesfully rank the rows by using a table function and RANK(). I wish for the data to look like:
Then I can remove the additional rows by filtering to only show Rank 1. I have successfully accomplished this task in Workday's PRISM, however due to the restrictions PRISM has on refreshes I wish to do this in PowerBI to ensure the data is up-to-date in real time. Any help or tips would be greatly appreciated, thanks.
Solved! Go to Solution.
HAve you tried Calculate Function?
Proud to be a Super User!
I have but was unable to get it to work, could you give me any tips on how to use Calculate to accomplish this?
Calculate (Average(column), filter(table name, rankcolumn = 1)), try this
Proud to be a Super User!
The values are text so I don't believe Average will work.
User | Count |
---|---|
83 | |
77 | |
71 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |