Creating Calendar Table in Power BI using DAX Functions

preview_player
Показать описание
I have previously explained about using Power Query for creating calendar tables, However, some people still love to do that in DAX. There are a couple of DAX functions which makes the process of creating a calendar table very simple and easy; Calendar() and CalendarAuto(). In this short video, I'll explain what are these functions, and how you can use them to create a calendar table in just a few seconds.
The dataset for this sample can be found in my article below:

Learn More:
Do You Need a Date Dimension?

Power BI Date Dimension: Default or Custom? Is it confusing?

Creating Date Dimension in Power Query Part 1: Calendar Columns

Creating Date Dimension in Power Query: Part 2: Fiscal Columns

Creating Date Dimension in Power Query: Part 3: Public Holidays

Related Videos:
How to Create a Date or Calendar Table and Dimension in Power BI using Power Query

Date Dimension in Power BI with Financial or Fiscal Columns
Рекомендации по теме
Комментарии
Автор

Good job sir. You are really a borne teacher, what more can I say: Weldon sir. Please do more tutorials on DAX as it carries 70% of the whole Power BI learning circle. Bless you, sir.

datalab
Автор

Straight on point what I was looking for

philipwatuma
Автор

Hi Radacad, I am not sure but I think that you have a video where you explain how to use one dimention date file for multiple files. If you have it can you please let me know the name of the video please, thank you.

chavelooo
Автор

Calendar auto is great, does power bi has any other auto functions that would create month number, month name, year, etc. etc?

stephenbrincat