Looking for working example of Date table relationship

[cparker4486]

Hi everyone,

This is a follow up to my earlier post: Why is my Dates table relationship not producing the expected results?

I was thinking that instead of trying to relay where I've messed up it might be better if I asked for a working PBIX file that has this Date table relationship.

Does anyone know where I can download or have one to share?

Thanks!

[v-sihou-msft · Accepted solution]

@cparker4486

Based the screenshot in your previous screenshot, I can't figure out any issue on relationship management. But I still suggest you link two tables with DateKey column instead of Date column. I have tested with AdventureWorksDW sample database. It works properly.

I've attached .pbix file