show recent available data

[vanquisher11]

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,

[Eric_Zhang · Accepted solution]

---

@vanquisher11 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,

---

@vanquisher11

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

[Ashish_Mathur]

Hi @vanquisher11,

In your first table, you have Day 1, Day 2 etc. in the headings.  Is that how your data actually is or do you have actual dates there?

[pxg08680]

@vanquisher11

Create a calculated column this way