Forum Discussion
Identify the first time work is allocated out
Hi Pakv
Please consider this solution and leave kudos ....
First add a new report with a table visual withTicket[Ticket]
Earliest Allocation[Start Date]
Note that this displays all the start dates for each ticket. How annoying 😫
Now go to the relationship pane and click on each relationship and set them to Cross Filter Direction = Both and click ok. Check they are both set carefully.
Go back to the visual table you added before. It now just shows the first start dates for each ticket. 😃
"Cross Filter" does what it says on the tin and applies the filters from one table across to another, when using a bridge table.
Super UserHi Pakv
Please consider this solution and leave kudos ....
First add a new report with a table visual with
Ticket[Ticket]
Earliest Allocation[Start Date]
Note that this displays all the start dates for each ticket. How annoying 😫
Now go to the relationship pane and click on each relationship and set them to Cross Filter Direction = Both and click ok. Check they are both set carefully.
Go back to the visual table you added before. It now just shows the first start dates for each ticket. 😃
"Cross Filter" does what it says on the tin and applies the filters from one table across to another, when using a bridge table.
You are a hero.
I was trying to crack a nut with a hammer using DAX and all sorts of mad queries and joins having totally forgot about that option!
Thank you so much!
Paul