Power Bi relationships Not working

[Anonymous]

This question has been asked severally, but I have tried all solutions and have yet to get a breakthrough. 
I have a date table with a column as follows.

The date column is a date data type with no Time values

The code for the Date table is as follows:

Complete  Date = ADDCOLUMNS(

CALENDAR(MIN(ProjectsWIPReportFromApril2020[date_completed]), MAX(ProjectsWIPReportFromApril2020[date_completed])),

"Year", YEAR([Date]),

"Month Year Num", CONCATENATE(YEAR([Date]), FORMAT([Date],"MMM")),

"Month Num", Month([Date]),

"Month", FORMAT([Date], "MMM"),

"Quarter Num",FORMAT([Date], "Q"),

"Quarter", CONCATENATE("Q",FORMAT([Date], "Q")),

"Day", FORMAT([Date],"D"),

"Week", CONCATENATE("Week ",FORMAT([Date], "WW"))

)

 I am connecting to a table column that is a date column in One to many relationships and Single. I have tried BOth Relationships as well and it's not working either.

The data type of the column connecting to the date table  is the date  

What ami doing wrong?

[DataVitalizer]

Hi @Anonymous 

Select your Date Table and Mark it (Table Tools Tab) so Power BI can recognize it 

Did it work ?  👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

[Anonymous]

Thanks @DataVitalizer , had already done this

[DataVitalizer]

If the issue keeps occuring, can you share a screen shot of the relation between tables and what you display in your visual. that would help more?

Did it work ?  👍 A kudos would be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

[Anonymous]

This is what it shows. @DataVitalizer 

[DataVitalizer]

Hi @Anonymous 
Do you mind sharing the pbix file with only the tables required?