Forum Discussion

Mart1980's avatar
Mart1980
Helper I
2 years ago
Solved

if statement custom column

Hello ,

 

I have these two date columns and what i want to do is create a custom column to check if month and year of one column matches the other and to return either true or false. Can someone please help me with the steps to follow on this?

Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    2 years ago

    Mart1980 add a new column using this expression:

     

    New Column = EOMONTH ( Table[Date1], 0 ) = EOMONTH ( Table[Date2], 0 )

     

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    Mart1980 add a new column using this expression:

     

    New Column = EOMONTH ( Table[Date1], 0 ) = EOMONTH ( Table[Date2], 0 )