Forum Discussion

topkatt's avatar
topkatt
Frequent Visitor
8 years ago

Dynamically Retrieve Last Observation per ID

Hi All,   I'm trying to create a table that has the last observation for each ID in my data, relative to the current value in a date slicer.   Sample data below, thanks for your help!     I...
Need Help
topkatt's avatar
topkatt
Frequent Visitor
7 years ago
Ashish_Mathur wrote:

Hi,

 

You may download my PBI file from here.  i have changed some data there to verify.

 

Hope this helps.

 

Thank you so much for your help with this, though I have one additional question. Your solution is perfect for creating a visualization of the table I'm describing, but what If I want to make a visualization of the data in that table? I'm having trouble creating a table with this data that I can then use in other visualizations?

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

I will not be able to help with that.

  • topkatt's avatar
    topkatt
    Frequent Visitor
    7 years ago
    Ashish_Mathur wrote:

    Hi,

     

    I will not be able to help with that.

     

    Thanks for the feedback. Do you think this is something that isn't possible using Power BI? I'm wondering if my search for a solution is in vain.