Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |