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] ) )
)
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Share the link from where i can download your Excel file.

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!