Forum Discussion

debenaire's avatar
debenaire
Helper I
2 years ago

Time Travel Reporting?

Hi, I am storing data which timestamps any changes to records and inserts them into a table as a new record. As such there will be duplicate IDs but with slightly different data where there have been...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi debenaire ,

Can you give us a sample data table, so that we can help you solve the problem quickly, thank you.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

debenaire's avatar
debenaire
Helper I
2 years ago

Thank you. see attached example where we can see different entries for the same dataset id, based on the parameter / slicer selected in a visual it would filter the table to the results seen. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi debenaire ,

    Below is my table:

    It doesn't need DAX to implement your result plot, just slicer filtering.Maybe I misunderstood the whole process

    The final output is shown in the following figure:

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.