Forum Discussion

MortimerMcFly's avatar
MortimerMcFly
Frequent Visitor
2 years ago
Solved

Max Value and Value -1 / Version

Hi all,    this is probably not the hardest but I feel a little hopeless after trying for a while now.    my Situation:   I have a table with some names, delievery_dates, uuid, and a version nu...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    Hi MortimerMcFly - Can you try the below calculated column in you dataset.

     

    calculated column calculation FYR:

     

    ExpectedOutput =
    VAR MaxVersion =
        CALCULATE(
            MAX('FCP'[Version]),
            ALLEXCEPT('FCP', 'FCP'[Name], 'FCP'[Delivery])
        )
    RETURN
    IF('FCP'[Version] = MaxVersion, "Plan", "FC")

     

     

     

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

rajendraongole1's avatar
rajendraongole1
Icon for Super User rankSuper User
2 years ago

Hi MortimerMcFly - Can you try the below calculated column in you dataset.

 

calculated column calculation FYR:

 

ExpectedOutput =
VAR MaxVersion =
    CALCULATE(
        MAX('FCP'[Version]),
        ALLEXCEPT('FCP', 'FCP'[Name], 'FCP'[Delivery])
    )
RETURN
IF('FCP'[Version] = MaxVersion, "Plan", "FC")

 

 

 

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