Power BI Tutorial Blogs

How to create a date table in Power BI with a ready-made Excel file

If you don’t have access to a date table in a source database or if you’re new to Power BI and aren’t that comfortable with programming in DAX or M then sign up to my mailing list and get the link to download a ready-made excel date table. You can import this into Power BI, mark as a date table and start using it straight away.

How to create a DAX date table

So you’ve decided to create a date table in Power BI using DAX, good choice! If you’re new to DAX this blog will guide you through creating the table from start to finish. If you already know how to use DAX and just want to copy some calendar code go directly to the code section here.

How to create a Power Query M date table

This blog walks you through the stages of creating a Power Query date table, using the in-built functionality to create columns of date information. If you’d prefer to copy and paste the final M code and set up a table quickly now, then jump to the code section here.

Power Query M code for creating a date table

You can quickly set up a date table in Power Query by simply copying the M code below into a blank query. The steps used to generate the code are explained in this blog here.
Follow these steps to set up an M code date table in just a few minutes

How to order months chronologically in Power BI

Change from sorting months Apr, Aug, Dec to Jan, Feb, Mar. This method creates a separate month table and brings it into Power BI to order months chronologically.

I have a video on my YouTube channel explaining this method or you can use this easy-to-follow guide:

About Me

Hi, I’m Jo. Previously a Business Intelligence (BI) Manager for 2 central London councils. I now freelance and create tutorials on this blog and on YouTube with the aim to help demystify BI and data analysis. Hopefully I can do my bit to make people realise data is beautiful not scary.

Processing…
Success! You're on the list.

%d bloggers like this: