Forum Discussion
sudhav
Helper V
Helper VNeed partition in ranking in power query editor or Dataflows in Fabric
Hi Team, I have a CTE in my sql which is giving ranking in a table and below is the code select *, rank() over(partition by Empstatus,Emprole,Empdept order by empid) as Empid_Rank from EmployeeT...
miguel
Community Admin
Community Adminhi!
Could you please share a more thorough example on what you're trying to achieve? if you can share a sample dataset and a sample output that would help us understand more what you're trying to accomplish without being directly associated with a language different than the one used by Power Query (inside of Dataflows).
As a more generic answer, when it comes to doing ranks in Power Query you can use the Rank column feature as described in the article below: