Forum Discussion
Solved
If 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')
But 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.