View modified data at a certain time

[Anonymous]

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 modification	Field modified	Old value	New value	ID
14/10/2022	First Name	Chare	Charles	AAABBB
15/10/2022	Last Name	Doo	Dom	BBBCCC

The present data has a structure like this:

First Name	Last Name	ID
Charles	Frey	AAABBB
Adam	Dom	BBBCCC

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 Name	Last Name	ID
Chare	Frey	AAABBB
Adam	Doo	BBBCCC

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 !

[v-yinliw-msft]

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]

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.