If with two column

[DavidB023]

Hi everybody !

I want to create an if function between two tables.

In fact, if I have nothing in a specific column in my second table, my personalize column (my function) take the number 3.

I try with contain but unsuccessful.

Here is my example : Table 1

 Table 2

 My two tables have same rows.

Thanks

Best regards

David

[quentin_vigne]

Hi @DavidB023

You can simply use = or <> with LEFT() or RIGHT()

For example your date is 01/01/2018 and you want to verify if it contains 2018 type :

Column = IF(RIGHT(Table[DateColumn];4)="2018";0;3)

Hope this help

- Quentin