Forum Discussion
I can´t create a table withou create a circular dependency
PirataFabri
1. Merge WorkItems table with FluxoPadrao table (Join on WorkitemType) and retrieve different states of each workitem type)2. Merge the result (from point 1) with WorkItemRevisions table (Join on WorkitemId) and retieve StatechangeDate.
To achieve your desired output (with StateInDate and StateOutDate), I think you need to give an index column for both Workitems table and FluxoPadrao Table before performing the above merge operations. If you need any further help, please share the pbix file along with the sample data file.If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Work Items table
FluxoPadrao Table
------------
Desired FA_WorkItems Table
--------------
WorkItemRevisions Table
PirataFabri
1. Merge WorkItems table with FluxoPadrao table (Join on WorkitemType) and retrieve different states of each workitem type)
2. Merge the result (from point 1) with WorkItemRevisions table (Join on WorkitemId) and retieve StatechangeDate.
To achieve your desired output (with StateInDate and StateOutDate), I think you need to give an index column for both Workitems table and FluxoPadrao Table before performing the above merge operations. If you need any further help, please share the pbix file along with the sample data file.
If the post helps please give a thumbs up
If it solves your issue, please accept it as the solution to help the other members find it more quickly.
Tharun
Worked perfectly. I was already able to create all the table I needed. Thank you very much!