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

Hi there. You should consider do this in Power Query over the query editor. If you want DAX use the first answer, if you want power query try adding a custom column like this:

 

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

 

Just ask if columnA is blank and you can get the true false with the columns.

 

Hope this helps,

Regards

EmilyM2019's avatar
EmilyM2019
Helper II
6 years ago

Hi,

 

Thanks for coming back to me. I'm now trying to do this in Power query but it hasn't worked. Using the add custom column option I have done:

 

= Table.AddColumn(#"Renamed Columns2", "Custom", each if[Column A]=""then[Column B]else[Column A])

 

and it isn't working. The only value that is returning in the new custom column is the value of column A.

 

Any ideas? 

  • ibarrau's avatar
    ibarrau
    Super 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
      Helper 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
        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,