show recent available data

---

Anonymous wrote:

I want to show the recent available data not the most recent data. say I have a table below.

 

 

 

 

 

 

 

 

Given the above table, I want to show a table similar to below

 

 

 

 

 

 

 

but instead, I'm getting this table

 

 

 

 

 

 

 

Any solution into this problem? how do I solve this issue where in I wanted to show the recent available data not the recent data? Thank you!

 

Many thanks,

---

Anonymous

I'd suggest re-model the data by unpivot.

Then create a measure as below. See more in the attached pbix file.

Measure = SUMX(FILTER(yourTable,yourTable[day]=MAX(yourTable[day])),yourTable[Value])