Forum Discussion
Creating a custom column with a New word if date column is empty or null
Hi, Trying to manage data that is missing info. I have one column that shows type of 'termintaed' or 'new hire'. I have another column that shows 'acquired date' . The column that shows acquired d...
Hi Anonymous ,
You could create a calculated column using IF() and ISBLANK() function.
https://docs.microsoft.com/en-us/dax/if-function-dax
https://docs.microsoft.com/en-us/dax/isblank-function-dax
Best Regards,
Jay
lbendlin
Super User
Super UserYou do that in Power Query Editor, or in DAX as a calculated column (not as a measure)
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.