Replace blanks in calculated column with another columns value

[Anonymous]

Hi Team,

CAn someone help me here?

I have one calculated column. If calculated column is BLANK then "Manager name value"

Input:

 

Output:    

Calculated column	Manger Name
Amit	Robin
Monu	Monu
Zack	Zack
Ganesh	Ganesh
Neha	Sharayu

[AlexisOlson]

If your calculated column is

Calculated Column = <Some DAX Expression>

Then you can change it to

Calculate Column =
VAR Calc = <Some DAX Expression>
RETURN
    IF ( ISBLANK ( Calc ), TableName[Manager Name], Calc )

[Anonymous]

My claculated column have 30 simple if else statements.

Will you solution work in that case?

[Anonymous]

Hi @Anonymous ,

What does "30 simple if else statements" mean? Could you please give me some examples? Please review the method in the following links, hope they can help you.

Show if field is blank or not

Using Advanced DAX For Multiple IF Statement In Power BI

Write Conditional Statement Using SWITCH in DAX and Power BI

Best Regards