Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

View modified data at a certain time

Hello dear community,

 

I have a table that contains all the modifications that has been done to a value with an ID that can connect to the "present time" table.

 

This "history" table has the following columns and lines as an example:

Time of modificationField modifiedOld valueNew valueID
14/10/2022First NameChareCharlesAAABBB
15/10/2022Last NameDooDomBBBCCC

 

The present data has a structure like this:

First NameLast NameID
CharlesFreyAAABBB
AdamDomBBBCCC

 

Is there a way to have a slicer that can show me data from whatever time I want? For exemple if I set the slicer to 13/10/2022 it would show this:

 

First NameLast NameID
ChareFreyAAABBB
AdamDooBBBCCC

 

For the moment all I could do is to merge the "present" table with the "history" by ID and get the the data from the history table, but I don't know what I can do to be able to filter the data from the time that I want, if it's event possible...

 

I hope my question is clear enough, all help is greatly appreciated !

Need Help

2 Replies

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Community Support
    3 years ago

    Hi Anonymous ,

     

    You can try this method:

    New column:

    First Name2 =
IF (
    [ID] = "AAABBB",
    CALCULATE (
        MIN ( 'Table'[Old value] ),
        FILTER (
            ALL ( 'Table' ),
            [Time of modification] = MIN ( 'Table'[Time of modification] )
        )
    ),
    [First Name]
)

    Last Name2 =
IF (
    [ID] = "AAABBB",
    [Last Name],
    CALCULATE (
        MAX ( 'Table'[Old value] ),
        FILTER (
            ALL ( 'Table' ),
            [Time of modification] = MAX ( 'Table'[Time of modification] )
        )
    )
)

     

    Is this what your expect?

     

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi, thank you for your response. I don't really understand how this could solve my problem, since it only takes into consideration one ID which is AAABBB. What about BBBCCC? And since it is a column, how will it filter by date like I would want to? I'd like to "go back" to the date and view how the data was from that date.