Forum Discussion
Relationship issue between 2 tables (date columns)
the relationships propagate from Date to INCT tables, but not the other way round. So e.g. INCT ALL will not propagate any filters to INCT OPEN
You would need to do one of the 2:
1) new tables listing unique customers with joins to the 3 fact tables, same for the Assignment Groups2) append all 3 tables into 1, with additional column specifying original table name, the model is just 2 tables - Date and Union, as Customer and Assignment groups are in the same table they will act like one
Community Championthe relationships propagate from Date to INCT tables, but not the other way round. So e.g. INCT ALL will not propagate any filters to INCT OPEN
You would need to do one of the 2:
1) new tables listing unique customers with joins to the 3 fact tables, same for the Assignment Groups
2) append all 3 tables into 1, with additional column specifying original table name, the model is just 2 tables - Date and Union, as Customer and Assignment groups are in the same table they will act like one
I found were the problem came from, I had a time slicer and if I do not enter the start date as the minimal slicer date, I will have no data...
I do not know why now.
The problem is not solved, because I can see that when I put on a table indicator 'INCT all'[Opened date] and 'Date'[Date] columns:
Date column is empty for filled-in opened date
EDIT: I solved the problem by changing the column format (with Excel) in the csv I used before import it again in Power BI. Now 'Date'[Date] is well linked to 'INCT all'[Opened date].
By the way, is it recommended to set date table as "table date" (from the ribbon) ? Because it will erase the date hierarchy.
Thanks