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
)

4 Replies

  • 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
)