cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vanquisher11 Frequent Visitor
Frequent Visitor

show recent available data

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

 

pic1.PNG

 

 

 

 

 

 

 

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

pic2.PNG

 

 

 

 

 

 

 

but instead, I'm getting this table

pic3.PNG

 

 

 

 

 

 

 

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,

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator Eric_Zhang
Moderator

Re: show recent available data


@vanquisher11 wrote:

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

 

pic1.PNG

 

 

 

 

 

 

 

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

pic2.PNG

 

 

 

 

 

 

 

but instead, I'm getting this table

pic3.PNG

 

 

 

 

 

 

 

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.

unpivot.gif

 

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

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

Capture.PNG

3 REPLIES 3
pxg08680 Member
Member

Re: show recent available data

@vanquisher11

Create a calculated column this way

 

a1.PNG

Super User
Super User

Re: show recent available data

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?

Moderator Eric_Zhang
Moderator

Re: show recent available data


@vanquisher11 wrote:

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

 

pic1.PNG

 

 

 

 

 

 

 

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

pic2.PNG

 

 

 

 

 

 

 

but instead, I'm getting this table

pic3.PNG

 

 

 

 

 

 

 

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.

unpivot.gif

 

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

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

Capture.PNG