Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |