topic Re: Conditional new column in DAX Commands and Tips

Conditional new column

Vishal_2202 — Thu, 05 Jan 2023 09:59:49 GMT

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

tamerj1 — Thu, 05 Jan 2023 10:05:30 GMT

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

Vishal_2202 — Thu, 05 Jan 2023 10:18:33 GMT

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

tamerj1 — Thu, 05 Jan 2023 10:36:17 GMT

Pleae try

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

Vishal_2202 — Thu, 05 Jan 2023 11:04:40 GMT