I need to create column with fulldate from 2013

[Anonymous]

I have two table with enrollment data. I have first table have enrollments having from  2103 and second tabel having enrollmnets from 2021. i need to create a line chart comparing enrollments between these two tables. 

i need separate fulldate column in table to join these to this third table create a visual line based on the date. 

[mahoneypat · Accepted solution]

If the columns in your two enrollment tables are the same/similar, you should append the tables in the query editor, disable load on the originals and only load the appended table.  This will simplify your analysis/visualization.

Pat

[V-pazhen-msft · Accepted solution]

@Anonymous 

If you don't want keep the original tables, you can create a calendar table with full date, create link the calendar with your 2 tables. Then you can just create line charts using the calendar date with data in the other 2 tables.

Calendar = Calendar(Date(2013,1,1),Date(2021,12,31))

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[mahoneypat · Accepted solution]

If the columns in your two enrollment tables are the same/similar, you should append the tables in the query editor, disable load on the originals and only load the appended table.  This will simplify your analysis/visualization.

Pat