Missing data after create relationship with Calendar Table

[PBI_newuser]

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.

[v-janeyg-msft · Accepted solution]

Hi, @PBI_newuser 

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 Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PBI_newuser , relatioship seems fine. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[PBI_newuser]

Hi @amitchandak ,

Below is the sample pbix file.

https://we.tl/t-W5i7qdxdQV

By using Calendar table's date as filter:

 

By using Fact table's date as filter: