Forum Discussion

Casteless's avatar
Casteless
Icon for Helper I rankHelper I
9 years ago
Solved

Trying to calculate most recent classification

Suppose there are three columns:   CLIENT | Classification | Date 1          |   A                  | 1/1/2016 1          |   A                  | 1/1/2016 1          |   B                  | 2/...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    Casteless

     

    How about this?

     

    Classification on Last Date =
    IF (
        HASONEVALUE ( 'Table'[Client] ),
        CALCULATE (
            LASTNONBLANK ( 'Table'[Classification], 1 ),
            LASTDATE ( 'Table'[Date] )
        ),
        BLANK ()
    )

    Good Luck! :smileyhappy:

Casteless's avatar
Casteless
Icon for Helper I rankHelper I
9 years ago

Ah the problem was in the "totals" option again, why must that be turned to off for this to work?

Casteless's avatar
Casteless
Icon for Helper I rankHelper I
9 years ago

For some reason when i try to use this solution with my real data the "General" section of format is not available? so i can't turn off totals.

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Casteless

     

    How about this?

     

    Classification on Last Date =
    IF (
        HASONEVALUE ( 'Table'[Client] ),
        CALCULATE (
            LASTNONBLANK ( 'Table'[Classification], 1 ),
            LASTDATE ( 'Table'[Date] )
        ),
        BLANK ()
    )

    Good Luck! :smileyhappy:

  • Casteless's avatar
    Casteless
    Icon for Helper I rankHelper I
    9 years ago

    Sean,

    That works perfectly!

    I tried to use LastnonBlank in my original attempts but was lacking an expression.

    I was unaware you could put "1" for an expression, what does that mean?

     

    VVlarde thanks for your help as well!

  • Casteless's avatar
    Casteless
    Icon for Helper I rankHelper I
    9 years ago

    Why can i not turn off totals in the table as suggested?

     

     

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Casteless

     

    Try to Delete the measure of the visual and add again.

     

    Regards,