Forum Discussion

Mart1980's avatar
Mart1980
Icon for Helper I rankHelper I
3 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 pl...
Need Help
Show and Tell
  • parry2k's avatar
    parry2k
    3 years ago

    Mart1980 add a new column using this expression:

     

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

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
3 years ago

Mart1980 add a new column using this expression:

 

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