Forum Discussion

Frequent Visitor

3 years ago

Solved

Conditional new column

How to get max date value of column 1 if column 2 has value'xy' and column 3 has value'2'.

3 years ago

Pleae try

=
CALCULATE (
    MAX ( 'Table'[column1] ),
    'Table'[column2] = "xy",
    'Table'[column3] = 2
)

Frequent Visitor

3 years ago

But we can't define specific value from column 2 and column 3

Community Champion

3 years ago

Pleae try

=
CALCULATE (
    MAX ( 'Table'[column1] ),
    'Table'[column2] = "xy",
    'Table'[column3] = 2
)