Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

My Date Table not working

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?

 

Need Help

5 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

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

       

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional
    2 years ago

    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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      christinepayton
      Most Valuable Professional
      2 years ago

      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.