Forum Discussion
Replace blanks in calculated column with another columns value
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 ...
AlexisOlson
Super User
Super UserIf 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 )My claculated column have 30 simple if else statements.
Will you solution work in that case?
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.
Using Advanced DAX For Multiple IF Statement In Power BI
Write Conditional Statement Using SWITCH in DAX and Power BI
Best Regards