July 4, 2023
DAX
June 9, 2023
Key DAX Concepts you should know (part1)
Intro DAX is a Data Analysis EXpression language used in Power BI. I attended a Power BI conference sometimes last year where Ahmed Oyelowo mentioned the importance of knowing the theoretical aspect of the
September 20, 2021
DAX Formula To Rank Based On Multiple Values
Performing ranking in DAX is simple enough when you are considering just single numerical values. I mean, for example, it’s easy to rank Products based on Total Sales. But consider the scenario below. A
November 29, 2020
When to Combine ALL and FILTER – Functions in Focus (Part 2) –
In my previous post, I wrote about ALL and FILTER functions in DAX. And I mentioned that ALL is usually used as an argument in FILTER. When do you combine FILTER and ALL in
November 7, 2020
3 DAX Table Functions You Must Master
Writing DAX in Power BI is always against tables isn’t it? Our data are stored in tables, so analyzing them with DAX requires us to send DAX functions against the tables to carry out
October 19, 2020
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
October 12, 2020
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.
October 4, 2020
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
October 2, 2020
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
September 26, 2020
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.
7, Ropo Owolabi Street, Morgan Estate Phase 2, Ojodu, Lagos.