Forum Discussion

Elisa_E's avatar
Elisa_E
Icon for Helper I rankHelper I
8 years ago
Solved

LASTNONBLANK and MAX

Hello,   I have a very large dataset with multiple entries per account per year. I need to pull a text variable (contractor) into a new table based on the last year in the dataset. The issue is tha...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    Elisa_E

     

    May be a MEASURE like this

     

    LastContractor =
CALCULATE (
    MAX ( Table1[Contractor] ),
    FILTER ( Table1, Table1[Year] = MAX ( Table1[Year] ) )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

Elisa_E

 

May be a MEASURE like this

 

LastContractor =
CALCULATE (
    MAX ( Table1[Contractor] ),
    FILTER ( Table1, Table1[Year] = MAX ( Table1[Year] ) )
)
Elisa_E's avatar
Elisa_E
Icon for Helper I rankHelper I
8 years ago

Works perfectly. Thank you so much!