Time Intelligence - Relations issue

[ake]

Hi, Im want to implement a calendar table in my model, but the filters do not work if I make the relationship with between Created from table "CalendarA" and Created of the "Sol" table which is my fact table. but if I make the relationship between Created from table "CalendarB" (its the same table of CalendarA but with another name) to the column "fecha_entrega" of the fact table does work, but it's not what I want.

FILE: https://ufile.io/shb0hrja

Why this is happening? 

[v-yanjiang-msft]

Hi @ake ,

By your sample, I create a new simple table, which is the top seven rows of your “Sol”table, and I create relationship like you.

I use the data to create a visual, and it works fine,so I think there is no wrong with your relationship, but it’s the “Sol” table cause your problem, I have no access to open it in PowerQuery, you can theck it more.

Best Regards,
Community Support Team _ kalyj

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

[mahoneypat · Accepted solution]

The reason is that the Created column of CalendarA has a DateTime data type.  You need to change that to Date.  Also, the relationship with CalendarB is to your Fecha_entrega column, which is type Date.

Pat

[ake]

Thanks Mahonepat. That works perfect!