Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to Solution.
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
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |