Forum Discussion

Lejaregg's avatar
Lejaregg
New Member
6 years ago

Question: Issues with Calculated Column Using IF or SWITCH Logic

Hi,   Fairly new to Power BI and I can't seem to find what I am doing wrong via Google or this forum. I am looking to create a calculated column on a table (Dataset) that selects a row value based ...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Lejaregg ,

 

Try reversing the Switch Values;

 

Compare Column = 
SWITCH(
TRUE(),
ISBLANK('Dataset'[Column1]) && ISBLANK('Dataset'[Column2]) && ISBLANK('Dataset'[Column3]),
'Dataset'[Column4],
ISBLANK('Dataset'[Column1]) && ISBLANK('Dataset'[Column2]),
'Dataset'[Column3],
ISBLANK('Dataset'[Column1]),
'Dataset'[Column2],
NOT(ISBLANK('Dataset'[Column1])),
'Dataset'[Column1],
"")

.

 

Also, please share some sample data for us to check further.

 

Regards,

Harsh Nathani

 

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