BI-Jo – Medium

BI-Jo

BI-Jo

What method should you use to create a date table in Power BI?

A question that, when googled, will display pages of blogs and opinions. According to Microsoft there are at least 5 different options for…

Dec 1, 2020

What method should you use to create a date table in Power BI?

Dec 1, 2020

BI-Jo

What is a calendar table and why should I create one in my Power BI project?

If your Power BI project has more than one table with a date column or if you want to report on time periods other than year, month and…

Dec 1, 2020

What is a calendar table and why should I create one in my Power BI project?

Dec 1, 2020

BI-Jo

How to create 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…

Dec 1, 2020

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

Dec 1, 2020

BI-Jo

How to create a DAX date table in Power BI

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…

Dec 1, 2020

How to create a DAX date table in Power BI

Dec 1, 2020

BI-Jo

How to create a Power Query M date table

Using Power Query M to create a date table in Power BI is recommended by many Power BI developers, mainly because Power Query is where all…

Dec 1, 2020

How to create a Power Query M date table

Dec 1, 2020

BI-Jo

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…

Dec 1, 2020

Power Query M code for creating a date table

Dec 1, 2020

BI-Jo

How to order months chronologically in Power BI

Change from sorting months Apr, Aug, Dec to Jan, Feb, Mar:

Oct 17, 2020

How to order months chronologically in Power BI

Oct 17, 2020

BI-Jo

Are you living in a kettle?

Living in a city is like living inside a kettle.

Aug 29, 2019

Are you living in a kettle?

Aug 29, 2019

BI-Jo

What to Pack

Handy extras to take on your travels

Jun 11, 2019

What to Pack

Jun 11, 2019

BI-Jo

BI-Jo

I’m a data consultant with over 20 years experience. I want to help demystify data and it’s uses, essentially help people to ‘talk data’.

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams