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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
MrMP
Helper III
Helper III

return variable that is not blank

Hi all,

 

I have a calculated column with 5 variables inside. Each row is satisfying only 1 variable which means other 4 return blank.

Is there an easy way to actually return only that one variable that is not empty. This calculated column is used to split the dataset in 5 categories.

 

Thank you!

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @MrMP ,

 

I think the best way to do that is with a SWITCH and TRUE:

myColumn = 
VAR Var1 = BLANK()
VAR Var2 = BLANK()
VAR Var3 = 1
VAR Var4 = BLANK()
VAR Var5 = BLANK()

RETURN
SWITCH(
	TRUE(),
	Var1 <> Blank(), Var1,
	Var2 <> Blank(), Var2,
	Var3 <> Blank(), Var3,
	Var4 <> Blank(), Var4,
	Var5 <> Blank(), Var5
)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

View solution in original post

1 REPLY 1
selimovd
Super User
Super User

Hey @MrMP ,

 

I think the best way to do that is with a SWITCH and TRUE:

myColumn = 
VAR Var1 = BLANK()
VAR Var2 = BLANK()
VAR Var3 = 1
VAR Var4 = BLANK()
VAR Var5 = BLANK()

RETURN
SWITCH(
	TRUE(),
	Var1 <> Blank(), Var1,
	Var2 <> Blank(), Var2,
	Var3 <> Blank(), Var3,
	Var4 <> Blank(), Var4,
	Var5 <> Blank(), Var5
)

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors