Forum Discussion

ake's avatar
ake
Frequent Visitor
4 years ago
Solved

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 fa...
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    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

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

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.