I cant understand how isn't this have a million views by now? Its one of the best Guides there is on the web. And that includes How to Power BI channel. Fernan deserves better than this.
Hi Billson, its a minor difference, M Query - Calendar is "pre-loaded" and is basically another table on your data model. DAX - Calendar table is calculated on the fly, and so it doesn't take any space in your model Hope that helps!
Great explanation. Been searching for this for awhile. As a new user of power bi, this solves so many issues I’ve had on building my reports. Thank you!
Hi, can you advise on how to handle date columns from 3 different table sources, where date rows are not same, but I want to visualize in a single line chart to see the trend over the years? Currently, I am struggling with making 1 universal date for 3 different tables during the year on monthly basis.
is there a way to keep only last day data on the table but past 2 weeks line chart next to it on the same tab in power bi? This way i can see what is the ranking list as of today and how was the stats changing day by day on the chat for each ranked items past 2 weeks?
Fernan, I have been questioned by many of the interview how we can show the date of the sales amount. If there would be plenty sales occurred on the same date. Can you create a video for writing a Dax formula to bring the result?
Hello, thank you very much for your videos. I cannot create relationships between my date table and my employee tables because I already have a relationship between my employee tables and a unique USER ID. How could I manage including a relationship with my date table additionally? Thanks a lot
Hey Cindy thanks for watching my videos! is your unique user id creating a recursive issue with your date table? You can look at using TREATAS to create a virtual relationship: ua-cam.com/video/YALX5cDMSfc/v-deo.html
Hi Fernan... I have a simple date table created from list and then turned into table. It has no complications. I have some data sets which I want to link to the date table, however every relationship only allows many to many. There is clearly something wrong in the datasets but I cannot see what. The date table has a unique date per row and the dataset also has a unique date in one of its columns. Any idea why the relationship will not be a one to many? Have I perhaps created a bad relationship somewhere else? I have tried deleting all relationships and starting again but the dates don't work as expected.
![[Power BI] 💡 Creating a Calendar Table in the Power Query Editor 📅](http://i.ytimg.com/vi/XQItjpSasLQ/mqdefault.jpg)
Brilliant! Love the Reza Rad MCode Date table creation acknowledgement. You Rock!
I cant understand how isn't this have a million views by now? Its one of the best Guides there is on the web. And that includes How to Power BI channel. Fernan deserves better than this.
so helpful I will try both DAX and PQ methods
Awesome Video !!!
Best video
Thanks for this, Fernan! What is the advantage of the DAX approach vs the M code approach?
Hi Billson, its a minor difference,
M Query - Calendar is "pre-loaded" and is basically another table on your data model.
DAX - Calendar table is calculated on the fly, and so it doesn't take any space in your model
Hope that helps!
Great explanation. Been searching for this for awhile. As a new user of power bi, this solves so many issues I’ve had on building my reports. Thank you!
Hi, can you advise on how to handle date columns from 3 different table sources, where date rows are not same, but I want to visualize in a single line chart to see the trend over the years? Currently, I am struggling with making 1 universal date for 3 different tables during the year on monthly basis.
is there a way to keep only last day data on the table but past 2 weeks line chart next to it on the same tab in power bi? This way i can see what is the ranking list as of today and how was the stats changing day by day on the chat for each ranked items past 2 weeks?
Fernan, I have been questioned by many of the interview how we can show the date of the sales amount. If there would be plenty sales occurred on the same date. Can you create a video for writing a Dax formula to bring the result?
I get this error CALENDARAUTO function can not find a base column of DateTime type in the model.? all rows are error
Hello, thank you very much for your videos. I cannot create relationships between my date table and my employee tables because I already have a relationship between my employee tables and a unique USER ID. How could I manage including a relationship with my date table additionally? Thanks a lot
Hey Cindy thanks for watching my videos! is your unique user id creating a recursive issue with your date table? You can look at using TREATAS to create a virtual relationship: ua-cam.com/video/YALX5cDMSfc/v-deo.html
Hi Fernan... I have a simple date table created from list and then turned into table. It has no complications. I have some data sets which I want to link to the date table, however every relationship only allows many to many. There is clearly something wrong in the datasets but I cannot see what. The date table has a unique date per row and the dataset also has a unique date in one of its columns. Any idea why the relationship will not be a one to many? Have I perhaps created a bad relationship somewhere else? I have tried deleting all relationships and starting again but the dates don't work as expected.
Hi, can you help here? I tried the calendarauto, but it doesn't pickup my data's dates, it starts from 1899 and so on.