Recreate status history from changelog

[Anonymous]

I have a table of jira tickets with their CURRENT status, and I have a related table with the changelog of these statuses (state to, state from, timestamp)

I want to create a new table based on this that contains the status for each ticket for each day. Is there a way for this in PBI DAX?

The logic would basically be that create a table with all dates for each ticket from creationdate until closedate or today if not yet closed and a status column that would contain the to state value of the latest changelog by that date. 

[vanshsharma]

Sorry for opening a thread that's already been marked as answered but I'm facing a problem currently which I hope the OP can solve. You said that you have a second table with status from, status to and timestamp.
Could you please tell me how did you get this table? Did you use an addon/Plugin from the Atlassian marketplace or any API endpoint ? 
Thank you in advance

[Anonymous · Accepted solution]

Found a solution here: https://community.powerbi.com/t5/Desktop/Calculated-table-with-all-dates-between-two-dates/td-p/4179...