The Best 2 PL300 Resources
Of the many Microsoft Certification Exams, the Power BI Certification Exam, PL300 is one of the most popular. The PL300 Exam (formerly DA100) is a part of the new series of Microsoft Exams focused
Understanding Power BI Page Settings (Part 1)
Have you ever felt like the Power BI Page or Canvas is too small to fit all of the visuals you would like to have on a single page, and the way you want
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
How to use Native SQL Queries on Excel Data with Power Query
Using native SQL Queries against data sources can come with certain advantages. Chief among those advantages is the ability to push data transformation tasks to the data source level, rather than on Power Query
FinQuest Finance Provides Interest Free Loans For Our Courses
Happy New Year! It’s that time of the year for fresh announcements and we have an exciting one. Foresight BI Partners with FinQuest Finance Foresight BI & Analytics is partnering with FinQuest Finance to
Gentle Introduction To Variables In DAX
Beasty DAX DAX formulas can quickly become very complicated and difficult to read especially when you start to combine many functions in one single formula. Variables in a DAX is a way of breaking
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
Functions In Focus: ALL and FILTER (Part 1)
In my previous post, I introduced 3 Table Functions You Must Master. FILTER, ALL and VALUES. The reason you must master them is simple: they provide the most common ways for defining the kind
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
Thinking like DAX – Understanding Filters Context
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 Row Context
