how to get latest data as Total from different columns in Matrix

[devendrakotaru]

Hi All,

As shown in the below table, we need to get the total as the latest data 
for x row, Day 5  45 is the latest

for y row, Day 3 40 is the latest

for z row, Day 2 12 is the latest

	Day 1	Day 2	Day 3	Day 4	Day 5	Total
x	40	42	40	41	45	45
y			40			40
z	11	12				12

How to achieve this with the DAX?
Thanks in advance

[wdx223_Daniel]

=LASTNONBLANKVALUE(Table[Days],SUM(Table[Value]))