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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |