Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Linking Tables - dates

Hi,    I have a master Date table, and I'm trying to link it to a number of other tables, all with Year and Month. The Year and Month columns in my other tables are stored as Text, which I think mi...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    In the Other Table, generate a genuine date from the Month and Year by using this formula

     

    =1*("1/"&Table2[Month]&"/"&Table2[Year])

     

    Format this new column as Date and give it a meaningful heading.  Now create a relatioship from the Date column (that you just created with the formula above) of the Other Table to the Date column of your caalendar table.

     

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

In the Other Table, generate a genuine date from the Month and Year by using this formula

 

=1*("1/"&Table2[Month]&"/"&Table2[Year])

 

Format this new column as Date and give it a meaningful heading.  Now create a relatioship from the Date column (that you just created with the formula above) of the Other Table to the Date column of your caalendar table.

 

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you so much, Ashish_Mathur - this seems to have done the trick! 

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      You are welcome.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi Ashish_Mathur

         

        I've tried this same formula in a different table, and now I'm getting the below error message.

         

        Any ideas why?

         

        Thanks again for your help

         

        Sonia