Syntax Sugar – SUM Is SUMX In Disguise
Quick Introduction Do you know syntax sugar? May be not, but you know Sugar. It’s sweet. Writing DAX Measures usually require the use of Functions. The group of functions that always make it into
Practical Introduction to DAX (Intro to Row Level Security)
Using DAX to implement Data Confidentiality How does Power BI ensure confidentiality? Row Level Security (RLS) is one of the key features that allow report creators access level control on their Power BI reports.
Practical Introduction to DAX (Intro to Measures)
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
New DAX Course Launch
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
Practical Introduction to DAX (Intro to Calculated Columns)
Overview A calculated column is a column that is calculated in the model. Which means, it was not imported with the data. You see? The word “imported” was not casually included in that statement.
Practical Introduction to DAX ( Intro to Calculated Tables)
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
Practical Introduction to DAX in Power BI – Overview
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
Dirty Data Samples – Get Your Hands Dirty Cleaning Data
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
Most Common Power BI Installation Errors And Their Solutions
Resolving Issues With Power BI Desktop Installation Downloading and installing Microsoft Power BI Desktop should be a straightforward exercise. For a lot of people, it is, but for many others it is not. In
Power BI competition updates
On the 29th of June 2019, we announced the first global Power BI competition for cash prizes. The objective was to encourage an all round power bi skills upgrade. There were two categories to
