calendar table relationships

[Syndicate_Admin]

Hello experts

I have a calendar table, and I want to relate it to several tables, I make the first relationship of date of calendar table with the date of the sale, I do a test with a table of data but it does not give me any information of the date

what am I doing wrong?

Best regards!

[v-chenwuz-msft]

Hi @Syndicate_Admin ,

1 Check the depended column is right.

2 Make sure the relationship is active 

Or share your pbix file without sensitive data if you need more help.

Best Regards

Community Support Team _ chenwu zhu

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

[Greg_Deckler]

@Syndicate_Admin Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.