Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

I need to create column with fulldate from 2013

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...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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