Forum Discussion
Missing data after create relationship with Calendar Table
Hi,
I have created relationship between 2 Fact tables and Calendar table.
But, once I created the relationship, many data in "Work Order" table is missing.
Please help.
Hi, Anonymous
It’s my pleasure to answer for you.
According to your description, Your ‘enddate’ is the type of datetype and has a specific time but date in calendar doesn’t has specific time.when you create relationships it maybe go wrong.
You can create a column containing the date of ‘enddate’ and create relationships between it and calendar date.
Like this:
enddate = DATE(YEAR([End Date]),MONTH([End Date]),DAY([End Date]))
Here is my sample data. Hope it helps.If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey GuoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- v-janeyg-msft
Community Support
Hi, Anonymous
It’s my pleasure to answer for you.
According to your description, Your ‘enddate’ is the type of datetype and has a specific time but date in calendar doesn’t has specific time.when you create relationships it maybe go wrong.
You can create a column containing the date of ‘enddate’ and create relationships between it and calendar date.
Like this:
enddate = DATE(YEAR([End Date]),MONTH([End Date]),DAY([End Date]))
Here is my sample data. Hope it helps.If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey GuoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Super User
Anonymous , relatioship seems fine. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi amitchandak ,
Below is the sample pbix file.
By using Calendar table's date as filter:By using Fact table's date as filter:
