Forum Discussion
Creating a date table by combining two existing date tables from different data sources
Ziyad,
You can follow the below steps to get this done.
I have created 2 tables Sheet1 and Sheet2
Using these 2 tables i have created another table using Append option fro Query editor Edit Queries ==> Append Query (using Append Queries in new - You can append in same table as well)
This will have data like below (i have used the comment column only to indentify the different values. You can use your own)
Then click on "Close and Apply". Create your report using this new table.
If this solves your problem please accept this as solution.
Thanks,
Sunil
That is the idea, but I cannot figure out the query to combine the two existing date tables into one. Any ideas?
Following up on Anonymous 's response, this blog post provides a decent overview of how to create a date dimension:
https://www.mssqltips.com/sqlservertip/4857/creating-a-date-dimension-table-in-power-bi/
There's also this one, which I prefer since I can easily adapt it to new data or to different reports (this is the date model I currently use):
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
Based on your data, you might need to modify your date/time column to just a date column to make it work. If you need both date and time, you might consider this advice (which would require you splitting your date/time column into date and time columns supported by date and time dimensions.):
https://ginameronek.com/2014/10/01/its-just-a-matter-of-time-power-bi-date-time-dimension-toolkit/