My Date Table not working

[Anonymous]

Hi there,

I have some data table with Year and Month columns, and I've set up a Date table. However the relationship isn't working, as the visual results only have data but without date in it.

Can you help me please?

[Anonymous]

Thank you for your reply.

I put the Year to Date column, however, I know Year is Whole number, but there is a Year column in Date table, so I thought it might work, unfortunately, it didn't

[christinepayton]

The year column never needs to be a date type, I would make them whole number on both ends. But if your data is at the granularity of month, and you already have a year and month column in your fact table, I'm not sure why you're needing a date table at all? Is it to get the quarter? You might be better off with a date table that is at the month granularity and related on the month column if you're not using it for anything else. 

[christinepayton]

What do you have the relationship on? If your date table is by day and you're making the relationship between the month columns, it's going to be many to many which may be somewhat problematic. Make sure the data type of both columns in the relationship is the same as well. 

[Kishore_KVN]

Hello @Anonymous ,

Please change cross filtering as both direction and try. 

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

[Anonymous]

Still not working even after I changed the filtering to both direction😓