Forum Discussion
DAX: Pivot table with multiple values.
I have a table as below Emp ID |Managers |Roles A B Unit head A C Biz HR A D Biz HR A E Biz HR A F Ops Controller A G Biz HR Manager A H Budget Approver ...
AlB I got the solution buddy,
To get the ranks i tried the below dax,
And then i pivoted the table using below dax,
The only issue with this workaround is, each time i have manually add the column for the n no of emp id's
And i tried your dax, sorry, it didnt worked, the Ranks2 column is what the output in above image
Thanks,
Mohan V
