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 with this:

 

LastClassification = CALCULATE(VALUES(Table2[Classification]),LASTDATE(Table2[Date]))

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

That will return a multiple values error (even if i add distinct). 

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

    Casteless

     

    Can you have different classification in same day for a client?

     

    Using your sample Data i have this result

     

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

      Well this is odd, are you sure you copied in the duplicate dates?

      I am also using the sample data and I recieve the multiple values error.

       

      the measure:

      class2 = CALCULATE(VALUES(Testtable[class]),LASTDATE(Testtable[date]))

       

      the data: Testtable

       

       

      • 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?