“Bookmarks”? Yes, bookmarks. You know those thin strips in between books with the main purpose of referring to a particular page, which makes it easy to catch up later? Exactly. Bookmarks in PowerRead 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
Have you ever spent so much time working on a Power BI visualization that when you are finally done, you just wish there was a way for the summary report to write itselfRead More
Introduction Struggling to write measures is usually down to one’s understanding of Filters context. This is because DAX is computed based on an Evaluation context which consists primarily of 2 contexts: The RowRead 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
When talking about charts that are uncommonly used in Power BI, Waterfall Chart is usually not so far down on the list. Why? Who knows? Maybe users take one look at the chartRead 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
