Power BI Date Table

Power BI Date Table

Power BI Date Table

Power BI Dynamic Date Table

Create a dynamic Date table which will automatically add a day to the calendar, daily. The Date table is the most important table in your data model, as you can only use time intelligence DAX functions if your date table was created correctly. In Power BI date tables are important to allow you to create relationships.

Power BI Date Table - Custom

Sometimes it may happen that the financial year of your company is different from the calendar year.  In this video, I will show you how to create a custom date table which, for example, starts on the 27th of December    (and not on the 1st of January).

Power BI Dynamic Date Table

Create Year to Date, Month to Date and Week to Date Functions

Power BI:  In this video I will show you how to create Year to Date, Month to Date and Week to Date functions in the Power BI Query Editor and in DAX.  Use Year to Date, Month to Date and Week to Date functions to highlight important information  and to gain insights into the data of your dashboards.  Also, follow the training material and learn how to create these Date Dax Functions.

Compare Data between Custom Quarter Periods

In this video you will learn how to create a function which will show you the last value in a period as well as how to compare data between Custom Quarter Periods.

I want to mention that the Power BI Date Table may be the most important table of your data model.  You will be able to easily create relationships and DAX Time Intelligence Functions, based on this Date Table that you create in the Power BI Query Editor.

Feel free to subscribe to this website today, and start learning how to create a Date Table in Power BI.

Leave a Reply