Creating a date table in Power Query

I use “columns” and “fields” interchangeably in this post.

There are many posts out there showing how to create a date table and I believe this is because it’s a common problem that almost everyone encounters when first making a data model in Power BI, Excel, or Analysis Services.

By “common problem” I mean that it’s the one dimension that almost every data model shares, and fitting it to your data model can sometimes be a bit tricky.

You can create date tables in SQL, DAX, M, and many other programming languages.

In this post I want to show you how you can make a date table in Power Query’s M language, as well as explain what fields I think are important and how you can create them.

Continue reading “Creating a date table in Power Query”

Converting from UTC to Local Timezone in Power BI and Azure Analysis Services

This post is a quick response / supplement to Kasper’s post “Show the refresh date\time in a Power BI report and dashboard“.

Currently there is a small issue when using the DateTime.LocalNow() (and other similar functions) within the Power BI Service or Azure Analysis Services when processing a refresh of data.

Continue reading “Converting from UTC to Local Timezone in Power BI and Azure Analysis Services”