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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

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

 

Hope this helps.

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.