ISNULL handing using Dax or Power query by creating new column

[Anonymous]

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.

[PattemManohar]

@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())

[Anonymous]

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.

[PattemManohar]

@Anonymous Add New Column in Data pane using "New Column" option not in "Power Query Editor"

[Anonymous]

@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"

[PattemManohar · Accepted solution]

@Anonymous Ok !! Here it is to achieve the same output in "Power Query Editor"

Add a "Conditional Column" as below: