DAX for Power BI Part 7.1 - Creating Basic Calendar Tables in DAX

[@pnr8uk]

This man changed my life many many years ago with his SSRS tutorials :) I still watch them every now and again to feel a little bit of nostalgia! Good to hear your voice again on this topic.

[@WiseOwlTutorials]

Thanks so much! Really happy to hear that the SSRS videos were so useful and pleased to hear that you're enjoying the DAX videos too!

[@piotrkuc8936]

Another great lesson 👏

[@WiseOwlTutorials]

Thanks Piotr!

[@prasathv6258]

Please create more dax videos

[@seantame5865]

Great tutorial - even I can follow it!! One question from me. You called this table ReleaseCalendar. (forgetting the lower and upper bounds for a moment) could this table not also be linked to any other date in the model? Assume you have a Sales table with Order Date, Ship Date, Invoice Date etc, can you not link this one table to all of them or do you need one per date column? (sorry if you covered that but I did not notice it)

[@WiseOwlTutorials]

Hi! Yes, we do have a video on using single calendars or multiple calendars (although it's a subscriber-only video at the moment) kzbin.info/www/bejne/bJaVXo2LlJJpfdkfeature=shared You can see the full DAX playlist here kzbin.info/aero/PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX&feature=shared

[@PowerBILearner-c6d]

Hi. Why do we use the column name only instead of table name and column name in the functions calls that create the table columns? e.g. DAY([Date]), why isn't it DAY('ReleaseCalendar'[Date])?

[@WiseOwlTutorials]

Hi! It's because you're referring to the [Date] column produced by the CALENDAR function, not the physical Date column in the Release Calendar table.

[@samirmishra507]

what is the use to mark as Date Table, if we not mark it what could be the issue?

[@WiseOwlTutorials]

Hi Samir, you can read a detailed description here www.sqlbi.com/articles/mark-as-date-table/ I hope it helps!