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])

nandukrishnavs's avatar
nandukrishnavs
Community Champion
6 years ago

Anonymous 

 

I didn't understand your requirement clearly. Anyway, I have tried a few calculated columns.

Lastdate of warehouse = MAXX(FILTER(ALL('war_mut (2)'),'war_mut (2)'[warehouse]=EARLIER('war_mut (2)'[warehouse])),'war_mut (2)'[lmut_dat])

This will give you the last date in every warehouse.

 

 

Lastdate of warehouse and partnumber = MAXX(FILTER(ALL('war_mut (2)'),'war_mut (2)'[warehouse]=EARLIER('war_mut (2)'[warehouse])&&'war_mut (2)'[partnumber_sup]=EARLIER('war_mut (2)'[partnumber_sup])),'war_mut (2)'[lmut_dat])

This will give the last date of warehouse and partnumber combination.

 



Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂