Forum Discussion
Helper IShow Items due across multiple tables
I have multiple tables that have tasks and due dates, among many other things. I created a date table and established a relationship with the due date from each table with the overall date table, with a many (due) to one (date table) set up. I would like to make a table (or calendar) that shows the date with items due on that day by task ID, with each Task Type being a seperate a column.
Would be like...
| Due Date | Task Type 1 | Task Type 2 |
| 1/1/23 | ID 1 ID 2 | ID 3 |
This has been solved. It seems, as the video shows, this only works like this with the default visuals. Add visuals seems to disable this ability.
3 Replies
- amitchandak
Super User
DCS2011 , the way you displayed Task Type 2, is not possible. It will repeat or have row values
You need to have common dimension to disply things together
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda
