Forum Discussion
Historical column status
Dears, Could you please help me to find out how can track the old record status. Let's say that i have a table for activity: ID Name Activity 1 Mark null 2 Eli 04/03/2019 3 S...
Hey Anonymous ,
what is your data source and how is new data added there?
I'm afraid you have to solve that in your source system, that every activity is either a new file or a new row. In DAX it's easy then to find out the last 2 rows per user and calculate the difference in time.
If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
Best regards
Denis
Blog: WhatTheFact.bi
Thank you for your feedback, actually the data source will be from the API so I need to keep the history. I know that such thing should be in the source or in DWH by having the SCD to keep the history. But in case that I don't have a DWH so how this could be solved in the DAX, is this possible?