“DAX Evaluation Context”, just the name alone strikes fear into the heart of even seasoned Power BI developers. The reality however, is that Evaluation Context in DAX isn’t hard to understand, it’s simply hard to describe. In this session Brian Grant will use a technique called "Formula Decomposition" to visually break down a big DAX formula into a chain of smaller, bitsized subformulas; this in turn will create the platform needed for Brian to make the concepts of Evaluation Context both clear to understand and easy to remember.

At the end of the presentation you will both have a clear idea of how to visualize Row and Filter Context, and also understand how the subformulas leverage these contexts to produce the answers you see on a Power BI page. Furthermore, the next time you look at a big intimidating DAX formula, you will know how to break it down into bite sized chunks so they can be understand one at a time.

GUEST BIO (Brian Grant)
Hailing from the East side of beautiful Portland Oregon, Brian is a Senior Business Analytics consultant with local data heroes Skypoint. Having spent his early years deep in the study of acting and screenwriting, he finally graduated Summa Cum Laude with a degree in Economics. His driving belief is that the biggest barrier most people face when learning technology isn't technology at all, but language. Taught the right way, most people can learn most things; helping people learn skills that are "too technical" for them is his greatest joy. He is the author of the Elements of DAX series on YouTube.

RELATED CONTENT
Blog https://briangrantbi.blog
LinkedIn   / brianjamesgrant  
YouTube    / @skypointcloud  

LET'S CONNECT! ‍‍
  / havensbi  
  / reidhavens  
   / havensconsulting  

CHECK OUT OUR MERCH STORE
https://havensconsulting.creatorspr...

HAVENS CONSULTING PAGES
Home Page http://www.havensconsulting.net
Blog http://www.havensconsulting.net/blog...
Blog Files http://www.havensconsulting.net/blog...
Files & Templates http://www.havensconsulting.net/files...
Consulting Services http://www.havensconsulting.net/consu...
Online Course https://www.havensconsulting.net/onli...
Contact & Support http://www.havensconsulting.net/conta...

EMAIL US AT
[email protected]

#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #onelake #lakehouse #fabric #datawarehouse #evaluationcontext #filters