+2347080579790
info@foresightbi.com.ng
Foresight BI & Analytics Foresight BI & Analytics
  • About Us
    • Clients
  • Training
    • Courses
      • Power BI Training
      • Excel Training
      • SQL Training
    • Power BI Bootcamp
    • Gallery
  • Consulting
  • Blog
  • Resources
    • Videos
    • Tips & Tricks
  • Contact Us
  • About Us
    • Clients
  • Training
    • Courses
      • Power BI Training
      • Excel Training
      • SQL Training
    • Power BI Bootcamp
    • Gallery
  • Consulting
  • Blog
  • Resources
    • Videos
    • Tips & Tricks
  • Contact Us

Welcome to Foresight BI & Analytics Global Solutions (Foresight BI), a Business Intelligence and Data Analytics firm, focused on delivering world-class Training and Consulting Services.

7, Ropo Owolabi Street, Morgan Estate Phase 2, Ojodu, Lagos.

+234-7080579790

info@foresightbi.com.ng

ENROLL FOR COURSES
ENROLL FOR COURSES

Welcome to Foresight BI & Analytics Global Solutions (Foresight BI), a Business Intelligence and Data Analytics firm, focused on delivering world-class Training and Consulting Services.

7, Ropo Owolabi Street, Morgan Estate Phase 2, Ojodu, Lagos.

+234-7080579790

info@foresightbi.com.ng

DAX

Homepage › DAX
Dec 16, 2022

Is AVERAGE the right DAX function for Average?

DAX 3909 Views

Introduction The most used functions in DAX have to be SUM(), COUNT() (and it’s colleagues) and AVERAGE(). There is no big deal with the first two. AVERAGE() however, has to be properly thoughtRead More

Sep 20, 2021

DAX Formula To Rank Based On Multiple Values

DAX, MICROSOFT POWER BI 6301 Views

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

Dec 5, 2020

Gentle Introduction To Variables In DAX

DAX, MICROSOFT POWER BI 989 Views

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 ofRead More

Nov 29, 2020

When to Combine ALL and FILTER – Functions in Focus (Part 2) –

DAX, MICROSOFT POWER BI 15249 Views

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

Nov 19, 2020

Functions In Focus: ALL and FILTER (Part 1)

DAX, MICROSOFT POWER BI 2092 Views

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 theRead More

Nov 7, 2020

3 DAX Table Functions You Must Master

DAX, MICROSOFT POWER BI 3929 Views

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

Oct 29, 2020

Thinking like DAX – Understanding Filters Context

DAX, MICROSOFT POWER BI 3033 Views

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

Oct 19, 2020

Syntax Sugar – SUM Is SUMX In Disguise

DAX, MICROSOFT POWER BI 1662 Views

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

Oct 12, 2020

Practical Introduction to DAX (Intro to Row Level Security)

DAX, MICROSOFT POWER BI 1254 Views

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

Oct 4, 2020

Practical Introduction to DAX (Intro to Measures)

DAX, MICROSOFT POWER BI 1570 Views

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

1 2

7, Ropo Owolabi Street, Morgan Estate Phase 2, Ojodu, Lagos

info@foresightbi.com.ng

+234-7080579790

Company

About Us
Consulting
Training
Courses

Consulting

Data Analytic & Reporting 
Business  Automation Services
Financial Modeling Services
Data Analytics Audit

Resources

Blog
Videos
Power BI Quick Support
Free Courses

Copyright © 2023 Foresight BI - Achieve More With Less. | All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Sitemap