Replace blanks in calculated column with another columns value

Question

Hi Team,&nbsp;CAn someone help me here?&nbsp;I have one calculated column. If calculated column is BLANK then "Manager name value"&nbsp;Input:&nbsp;&nbsp;Output:&nbsp; &nbsp;&nbsp;Calculated columnManger NameAmitRobinMonuMonuZackZackGaneshGaneshNehaSharayu&nbsp;

alexisolson · Answer

If your calculated column is&nbsp;Calculated Column = &lt;Some DAX Expression&gt;&nbsp;Then you can change it to&nbsp;Calculate Column =
VAR Calc = &lt;Some DAX Expression&gt;
RETURN
    IF ( ISBLANK ( Calc ), TableName[Manager Name], Calc )

anonymous · Answer

My claculated column have 30 simple if else statements.Will you solution work in that case?&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
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

Forum Discussion

Replace blanks in calculated column with another columns value

3 Replies

Related content

Replace existing image with another

Calculation groups to replace slow IF/SWITCH?

Replace null values of one column to another column.

Replace Values based on another table

Query editor replacing values based on another column

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