Forum Discussion

EmilyM2019's avatar
EmilyM2019
Icon for Helper II rankHelper II
6 years ago
Solved

DAX for date column

Hi all,   I am stuck with a DAX if someone can help me.   I have a table with 2 date columns, Column A and Column B.    I want a new column (Column C) that will look and see if there is a value...
Help me please
  • ibarrau's avatar
    ibarrau
    6 years ago

    I'm sorry I forget to add the null cases too. Try this:

    if [ColumnA] = "" or [ColumnA] = null then [ColumnB] else [ColumnA]

    Regards, 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi EmilyM2019 ,

 

Try the following:

 

Date = if(isblank('Table'[ColumnA]);'Table'[ColumnB];'Table'[ColumnA])