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 fo...
Need Help
v-yinliw-msft's avatar
v-yinliw-msft
Icon for Community Support rankCommunity 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.