Almost Everything you need to know about Dates in Power BI

Once upon a time, there was Power BI, with it came the struggle with date calculations.

While the struggle with date in Power BI comes in all shapes and forms. This article covers the following common solutions:

Original data come from Microsoft WorldWideImporter data. Power BI link to database with direct import method from localhost\SQLExpress.

I focus on the Sales Invoice data. The main date from the table is the [invoice date] column, but there are also 3 other date columns. The default format from Power Query is datetime. For our purpose, it is treated as a date.

Three measures are created:

Once data is loaded, the first thing to note is that Power BI assigned a default Date Hierarchy to the [InvoiceDate].

While I can use the Hierarchy to do many things. It is a strict calendar year hierarchy with only very basic calendar fields.

Related posts:

None of my years were passed without tears streaming down my face on some days when I came home from school. However, I know things will always be okay because I still have you at the end of the day…

It has been an exciting year here at OpenBlox, starting off with an idea that has now evolved through many iterations to become the game and world that it now is. Throughout this process, we have…

To understand how and why stress makes us gain weight, we need to look at how certain hormones work in your body. I promise not to make this article too heavy with medical jargon and the science…