Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Most recent calculation

Good day,   Hope somebody can help me with the following. I have below table. If I want to calculate the most recent Imut_dat of the partnumber_sup, I use below calculation (calculated column). ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , try like

    Measure =LASTNONBLANKVALUE(Table[partnumber_sup],max(Table[lmut_dat]))
    or
    Measure = maxx(SUMMARIZE(Table,Table[warehouse],"_1",LASTNONBLANKVALUE(Table[partnumber_sup],max(Table[lmut_dat]))),[_1])

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , try like

Measure =LASTNONBLANKVALUE(Table[partnumber_sup],max(Table[lmut_dat]))
or
Measure = maxx(SUMMARIZE(Table,Table[warehouse],"_1",LASTNONBLANKVALUE(Table[partnumber_sup],max(Table[lmut_dat]))),[_1])

Anonymous's avatar
Anonymous
Not applicable
6 years ago

AM 

Thanks for your help, looks good!