Though, DAX can be a very wide subject with so many details, behavioral patterns and performance considerations to learn. I introduced 5 Key DAX Concepts you should know in my previous post. IRead More
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 ofRead More
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.Read More
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 ALLRead More
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 carryRead More
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 itRead More
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 BIRead More
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 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 thatRead More
