Forum Discussion

Vishal_2202's avatar
Vishal_2202
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'.    
  • tamerj1's avatar
    tamerj1
    3 years ago

    Vishal_2202 

    Pleae try

    =
CALCULATE (
    MAX ( 'Table'[column1] ),
    'Table'[column2] = "xy",
    'Table'[column3] = 2
)
tamerj1's avatar
tamerj1
Community Champion
3 years ago

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

  • Vishal_2202's avatar
    Vishal_2202
    Frequent Visitor
    3 years ago

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

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      Vishal_2202 

      Pleae try

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