Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

ISNULL handing using Dax or Power query by creating new column

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

 

NameRank1Rank2Rank3Rank4Rank5Rank6Consolidated Rank
John1     1
Raj 22   2
Chris   3  3
Ryan    444

 

Thanks In Advance.

1 ACCEPTED SOLUTION

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

 

Add a "Conditional Column" as below:

 

image.png

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




View solution in original post

5 REPLIES 5
PattemManohar
Community Champion
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())

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Anonymous
Not applicable

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"

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Anonymous
Not applicable

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

 

image.png

 

image.png





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.