Overview In this series, I have introduced Calculated Tables, Calculated Columns, and It’s time to introduce Measures. Before moving on to introduce Row Level Security next week. Data Analysis Expressions (DAX), also usedRead More
Learning DAX Read until end (Gift included). DAX is NOT one of the easiest Languages to learn (It’s even harder to teach). Not without a lot of practice, and that must be onRead More
Overview Scatter Plots in Power BI ! Can you count how many times you have used Scatter Plots for Power BI reports? I can and it’s not a lot. And I know forRead More
What you should Know before we begin In my post on Overview of DAX the previous week, I stated that there are mainly four use cases of DAX in Power BI: Creating NewRead More
Background Let this mark the beginning of a new series on DAX Language. If you are trying to get your hands on this cunning Language, be my esteemed weekly guest. Before long, yourRead More
If you thought DAX was the only way to bring Calendar Tables to life, you thought wrong. Power Query is not left behind in the fun and we are about to see howRead More
We’ve gone through Part 1, Part 2, and now here we are in the 3rd & final method on how to create a Calendar Table on Power BI using DAX. It’s been an interestingRead More
Hello, welcome to part 2 of the series on Creating Calendar Tables in Power BI Last time I was here, I mentioned there are different ways of creating a custom calendar tables usingRead More
First, why do you need a Calendar Table, also popularly referred to as Date Tables? All reports include dates; MONTHLY, YEARLY, QUARTERLY, etc. and nearly all data sets have date fields. To makeRead More
Update: I have created a playlist of suggested solutions to the dirty datasets provided in this article. I used Microsoft Power Query on Excel. To Learn more about Power Query, get this excellentRead More
