Forum Discussion
Time Intelligence - Relations issue
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?
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
3 Replies
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
Thanks Mahonepat. That works perfect!
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
