Help! how can I extract a value from a table for item and last movement date

[Denpowerbi]

Aiuto! Ciao a tutti,scusate ma non sono molto pratico e devo poter calcolare l'ultimo valore (determinato dall'ultimo dato di inserimento del movimento) per singolo articolo in una tabella dove sono presenti molti articoli.Ho provato di tutto ma senza riuscirvi Se qualcuno ha qualche suggerimento lo ringrazio in anticipo 

Denis 

[devesh_gupta · Accepted solution]

@Denpowerbi You can try to create following measure:

LastValueForArticle = 
VAR MaxDate = CALCULATE(MAX('Articles'[Date]), ALLEXCEPT('Articles', 'Articles'[ArticleID]))
RETURN
CALCULATE(SUM('Articles'[Value]), 'Articles'[Date] = MaxDate)

This DAX measure does the following:

• It first calculates the maximum date for each article (MaxDate) by using CALCULATE and MAX functions. The ALLEXCEPT function removes all filters except for the ArticleID.

• Then, it uses CALCULATE again to filter the Value column to only include rows where the date matches the maximum date calculated earlier.
  
  

If you find this insightful, please provide a Kudo and accept this as a solution.

[Denpowerbi · Accepted solution]

Grazie!!!!!!  Mi sei stato veramente utile e gentile 

[Denpowerbi · Accepted solution]

Grazie!!!!!!  Mi sei stato veramente utile e gentile 

[devesh_gupta · Accepted solution]

@Denpowerbi Welcome! but I noticed that you marked your own thankyou comment as a solution... 

Can you please mark the actual solution as an accepted solution, it would be a great help to me and to others also.

[devesh_gupta · Accepted solution]

@Denpowerbi You can try to create following measure:

LastValueForArticle = 
VAR MaxDate = CALCULATE(MAX('Articles'[Date]), ALLEXCEPT('Articles', 'Articles'[ArticleID]))
RETURN
CALCULATE(SUM('Articles'[Value]), 'Articles'[Date] = MaxDate)

This DAX measure does the following:

• It first calculates the maximum date for each article (MaxDate) by using CALCULATE and MAX functions. The ALLEXCEPT function removes all filters except for the ArticleID.

• Then, it uses CALCULATE again to filter the Value column to only include rows where the date matches the maximum date calculated earlier.
  
  

If you find this insightful, please provide a Kudo and accept this as a solution.