comparison of values column wise in matrix

[Anonymous]

Hi Team, @Ritaf1983 , @rajendraongole1 , 

help me out with this,

I have table like,

DimensionName RankDimension      Sum of asd    new value        flag first value
Faclitiy                   2024-03                 7819    
Faclitiy                   2024-04                  7864                 7819          greater
Faclitiy                     2024-05                7931                  7864          greater
Faclitiy                     2024-0612              7934               7909              lesser

where asd is row in data and i want to get value column where it will give data according to RankDimension rankdimension is just a type and i need one value column also in table 

please help me to solve this out.

it will be greatly appriciated thank you in advance

[rajendraongole1 · Accepted solution]

Hi @Anonymous - Create a calculated column as below for new values

neww value =

VAR CurrentRank = 'Signalinfo'[RankDimension]

VAR PreviousRank = CALCULATE(

    MAX('Signalinfo'[RankDimension]),

    FILTER('Signalinfo', 'Signalinfo'[RankDimension] < CurrentRank && 'Signalinfo'[DimensionName] = EARLIER('Signalinfo'[DimensionName]))

)

RETURN

CALCULATE(

    MAX('Signalinfo'[Sum of asd]),

    FILTER('Signalinfo', 'Signalinfo'[RankDimension] = PreviousRank && 'Signalinfo'[DimensionName] = EARLIER('Signalinfo'[DimensionName]))

)

create another calculated column

flag1 =

IF(

    'Signalinfo'[Sum of asd] > 'Signalinfo'[neww value],

    "greater",

    "lesser"

)

Hope it helps

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!