Forum Discussion
show recent available data
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 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])
3 Replies
Anonymous
Create a calculated column this way
Hi Anonymous,
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?
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])
