Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Folk's,
Greetings!!
I need help on INULL handling using Dax or Power query by creating new column, Sample data below
Please help me how to achive "Consolidated Rank" column
Name | Rank1 | Rank2 | Rank3 | Rank4 | Rank5 | Rank6 | Consolidated Rank |
John | 1 | 1 | |||||
Raj | 2 | 2 | 2 | ||||
Chris | 3 | 3 | |||||
Ryan | 4 | 4 | 4 |
Thanks In Advance.
Solved! Go to Solution.
@Anonymous Ok !! Here it is to achieve the same output in "Power Query Editor"
Add a "Conditional Column" as below:
Proud to be a PBI Community Champion
@Anonymous Please try this...
Consolidated Rank = SWITCH(TRUE() ,RankTest[Rank1] <> BLANK(),RankTest[Rank1] ,RankTest[Rank2] <> BLANK(),RankTest[Rank2] ,RankTest[Rank3] <> BLANK(),RankTest[Rank3] ,RankTest[Rank4] <> BLANK(),RankTest[Rank4] ,RankTest[Rank5] <> BLANK(),RankTest[Rank5] ,RankTest[Rank6] <> BLANK(),RankTest[Rank6] ,BLANK())
Proud to be a PBI Community Champion
Thanks for your reply, I'm getting "Expression.Error: The name 'SWITCH' wasn't recognized. Make sure it's spelled correctly."
Swith will work on design side but i want it in Power query as a new column.
@Anonymous Add New Column in Data pane using "New Column" option not in "Power Query Editor"
Proud to be a PBI Community Champion
@PattemManohar Agree but i want to do it in Power Query because i need to apply some aggregation post to this logic.
If i do it in Data Pane i cant able to see that data in "Power Query Editor"
@Anonymous Ok !! Here it is to achieve the same output in "Power Query Editor"
Add a "Conditional Column" as below:
Proud to be a PBI Community Champion
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |