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 UserBut I am not sure by your question, cause as per your query if Company HQ is blank so it would return Sites otherwise Site.
You can try my suggested Dax and let me know if it not working.
Don't forget to give thumbs up 👍 and accept this as a solution if it helps you.
You can try my suggested Dax and let me know if it not working.
Don't forget to give thumbs up 👍 and accept this as a solution if it helps you.