Forum Discussion
HenryJS
Post Prodigy
Post ProdigyIf Statement
Hi all, How do I create a new column where IF 'CompanyHQ' is blank then use 'Site' value Else return 'Site' values Thanks, Henry
Column = If(ISBLANK('column you want to check'), 'column to return if previous is blank', 'column to return if there is a value')
Tahreem24
Super User
Super UserYou can create a calculated field with below DAX:
Column=if(ISBLANK('Table'[CompanyHQ, ]), TabIe[Site], Table[Site])
Column=if(ISBLANK('Table'[CompanyHQ, ]), TabIe[Site], Table[Site])