Forum Discussion

sharath123's avatar
sharath123
Icon for Helper I rankHelper I
4 years ago
Solved

Based on two column filter conditions , need calculated column DAX expression

Here we have Inspected dates as 26th Apr, 28th Apr, 3rd May, 4th May, 12th May, and 13th May (this is the latest date) based on the vehicle number & latest date we need to get the max damage i...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi sharath123 

    you can use

    max value of damage intensity =
VAR VehicleTable =
    CALCULATETABLE ( Table1, ALLEXCEPT ( Table1, Table1[Vehicle Number] ) )
VAR MaxDate =
    MAXX ( VehicleTable, Table1[Inspected Date] )
RETURN
    MAXX (
        FILTER ( VehicleTable, Table1[Inspected Date] = MaxDate ),
        Table1[damageIntensity]
    )
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi sharath123 

you can use

max value of damage intensity =
VAR VehicleTable =
    CALCULATETABLE ( Table1, ALLEXCEPT ( Table1, Table1[Vehicle Number] ) )
VAR MaxDate =
    MAXX ( VehicleTable, Table1[Inspected Date] )
RETURN
    MAXX (
        FILTER ( VehicleTable, Table1[Inspected Date] = MaxDate ),
        Table1[damageIntensity]
    )
sharath123's avatar
sharath123
Icon for Helper I rankHelper I
4 years ago

 Thanks tamerj1 It worked for me. you have given a detailed DAX expression, Thanks once again.