Calculate last value in a row

[castroeb]

Hi all, 

does any one know what can i do calculate the last value of a row?  I have created a matrix where is constanly changing WoW, in columns I have the week when I get the data and in rows I have the weeks that are being affected. for example in the SS below I want to add a mesure to calculate what would be the last value in the row of March 2nd  which would be 11790, how can I do that? 

[Greg_Deckler · Accepted solution]

So perhaps something like:

Max Week Received Phr = 
  VAR __Week = MAX('Sheet1'[Week])
  VAR __Table = FILTER(ALL('Sheet1'),[Week] = __Week)
  VAR __MaxWeekReceived = MAXX(__Table,[Week Received])
RETURN
  MAXX(FILTER(__Table,[Week Received] = __MaxWeekReceived),[Phr])

Sample data as text always helps to test. The above code is not tested. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[castroeb]

thank you Greg, I just tested the code you shared and it works perfectely. exactly what I was looking for. 

thank you once again for your help. 😀