Forum Discussion
Need Help with Date Modeling
Hello Community,
I need help with Data Modeling, here is my data model.
I want to display “INCIDENT CATEGORY” from Incident Table and “Task Category” from Task Table together on “Table or Matrix Visual” and “Date” slicer from Data Table.
I tried to changed Cross Filter Directions to “Both” but it is not working.
***Please note I have multiple columns in both tables and need to move on table and matrix visualization
Incident Table
| Date | Incident Category |
| 01-Jan-22 | A |
| 02-Jan-22 | B |
| 03-Jan-22 | C |
| 04-Jan-22 | D |
| 05-Jan-22 | E |
| 06-Jan-22 | F |
| 07-Jan-22 | G |
| 08-Jan-22 | H |
| 09-Jan-22 | I |
| 10-Jan-22 | J |
| 11-Jan-22 | K |
| 01-Jan-22 | L |
| 02-Jan-22 | M |
| 03-Jan-22 | N |
| 04-Jan-22 | O |
| 05-Jan-22 | P |
| 06-Jan-22 | Q |
| 07-Jan-22 | R |
| 08-Jan-22 | S |
| 09-Jan-22 | T |
| 10-Jan-22 | J |
| 11-Jan-22 | K |
Task Table
| Date | Task Category |
| 01-Jan-22 | 1 |
| 02-Jan-22 | 2 |
| 03-Jan-22 | 3 |
| 04-Jan-22 | 4 |
| 05-Jan-22 | 5 |
| 06-Jan-22 | 6 |
| 07-Jan-22 | 7 |
| 08-Jan-22 | 8 |
| 09-Jan-22 | 9 |
| 10-Jan-22 | 10 |
| 11-Jan-22 | 11 |
| 01-Jan-22 | 12 |
| 02-Jan-22 | 13 |
| 03-Jan-22 | 14 |
| 04-Jan-22 | 15 |
| 05-Jan-22 | 16 |
| 06-Jan-22 | 17 |
| 07-Jan-22 | 18 |
| 08-Jan-22 | 19 |
| 09-Jan-22 | 20 |
| 10-Jan-22 | 21 |
| 11-Jan-22 | 22 |
***Date Table has data from 01/01/2022 to 12/31/2022
3 Replies
tejapowerbi123 , Create a table and join with both columns
@Here is my data model as per your suggestions,still not working.
amitchandak In my scenarios I have a date table which is my Bridge Table.Still it is not working
