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
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.
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
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
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
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
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
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
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
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
