Forum Discussion

EmilyM2019's avatar
EmilyM2019
Helper 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, 

ibarrau's avatar
ibarrau
Super User
6 years ago

Well it should be similar

 

if [ColumnA] = "" or [ColumnA] = null then
if [ColumnB] = "" or [ColumnB] = null then 
DateTime.LocalNow() 
else [ColumnB] else [ColumnA]

 

You can continue adding if statements in the "then" or "else" in case you need them.

Regards,

EmilyM2019's avatar
EmilyM2019
Helper II
6 years ago

Thanks for your help.