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 used in
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 on top
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 for sure
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 New Tables
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, your DAX
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 how it’s
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 interesting journey
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 using DAX.
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 make it
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 excellent book