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, 

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
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, 

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

Thank you, this has worked, hurrah.

 

Just to build on this how would I do:

 

If column A and column B are blank then return todays date?

  • ibarrau's avatar
    ibarrau
    Icon for Super User rankSuper 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
      Icon for Helper II rankHelper II
      6 years ago

      Thanks for your help.