Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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:

IDNameActivity
1Marknull
2Eli04/03/2019
3Suo15/04/2019

 

so I will add a calculated column to say that the person who has null means INActive user and the on has date is active, let us say that Eli did a new activity in 28/04/2019 so the filed will be over written, therefore, i need to know when the last active date for Eli so I can know the duration between the two period. 

 

I was thinking about the incremental load, but is this will update the current value, but is it possible to store such values in different table "History table that will not be updated" and whenever a new records loaded it will be inserted there. . 

 

Any Idea. 

General Comment
Need Help
Tips and Tricks

3 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    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
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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?