How request in DAX a model based on historical value changes to follow the variations

[Agnes_BOURLON]

Hi

I created a table containing an extract of JIRA tickets story points

I want to launch every date an update for adding new tickets or the old tickets updated like : 

01.01 / ticket_1 / 20 

01.01 / ticket_2 / 10

01.01 / ticket_3 / 10

01.02 / ticket_4 / 10

01.02 / ticket_1 / 5

01.03 / ticket_5 / 3

I would like to get a visual showing the total of the story points by day (daily extraction)

01.01 /  40 (20+10+10)

01.02 /  35 (5+10+10+10) => I add the ticket_1 last value to the other tickets not updated on 01.02

01.03 /  38 (5+10+10+10 + 3)

How create a  table with the dates in rows, that have the hability to calculate the sum of all the story points from the daily extraction , being capable to get the last value of a ticket on the date corresponding to the row to aggrage correctly all the values ?

I don't want to duplicate each day all the JIRA tickets, I want just to get the dialy changes to reconstruct the story point backlog each day and be able to see the evolution on a whole year, for sample.

Is there some tips to know ? is it a data pattern known? 

Thanks in avance for your help

Agnes

[lbendlin · Accepted solution]

Power BI has no memory . You need to manage your snapshots in the upstream system (in your case the JSON responses from your API calls to JIRA), and then either import all snapshots or do your own delta/CDC processing.