Conditional new column

[Vishal_2202]

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

[tamerj1]

Hi @Vishal_2202 
Please try
CALCULATE ( MAX 'Table'[column1] ), ALLEXCEPT ( 'Table', 'Table'[column2], 'Table'[column3] ) )

[Vishal_2202]

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

[tamerj1 · Accepted solution]

@Vishal_2202 

Pleae try

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

[Vishal_2202]

Thanks @tamerj1