Forum Discussion
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...
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.
I get an error in query editor, says it can't convert text
can you share the screenshot of the error?