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:

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,

 

 

 

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: