Uploaded February 2024 | Updated November 2026, 21 hours ago
Join us to complete a Workout Wednesday challenge together! Weโll review the challenge, provide all the resources you need, and build a report live with you! Bring any questions you may have for us as we build!
GUEST BIO (Shannon Lindsay) ๐ค
Shannon is a data and analytics witch with a background in global public health. Sheโs currently casting spells at Microsoft, working to ensure Power BI is accessible to all users. Shannon spends as much time as possible in the data community, participating in user groups and working with the fabulous Workout Wednesday team.
RELATED CONTENT ๐
Workout Wednesday -- workout-wednesday.com/pbi-2024-w06
Original challenge by Ann Jackson -- workout-wednesday.com/2021w02tab
Dataset -- https://data.world/annjackson/20194-tableau-superstore
Power BI challenge -- workout-wednesday.com/pbi-2024-w06
Downloadable solution file -- community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2024-Week-6/m-p/3684599#M11939
Steph's blog post on adding a row rank -- data-witches.com/2020/10/21/adding-a-row-rank-based-on-a-different-column-with-power-query
VIDEO CHAPTERS ๐บ
0:00 - Video Start
5:00 - Start of Livestream
LET'S CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ๐
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE ๐
-- havens-consulting.creator-spring.com
HAVENS CONSULTING PAGES ๐
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #workoutwednesdays #workoutwednesday
Join us to complete a Workout Wednesday challenge together! Weโll review the challenge, provide all the resources you need, and build a report live with you! Bring any questions you may have for us as we build!
GUEST BIO (Shannon Lindsay) ๐ค
Shannon is a data and analytics witch with a background in global public health. Sheโs currently casting spells at Microsoft, working to ensure Power BI is accessible to all users. Shannon spends as much time as possible in the data community, participating in user groups and working with the fabulous Workout Wednesday team.
RELATED CONTENT ๐
Workout Wednesday -- workout-wednesday.com/pbi-2024-w06
Original challenge by Ann Jackson -- workout-wednesday.com/2021w02tab
Dataset -- https://data.world/annjackson/20194-tableau-superstore
Power BI challenge -- workout-wednesday.com/pbi-2024-w06
Downloadable solution file -- community.fabric.microsoft.com/t5/Data-Stories-Gallery/Workout-Wednesday-2024-Week-6/m-p/3684599#M11939
Steph's blog post on adding a row rank -- data-witches.com/2020/10/21/adding-a-row-rank-based-on-a-different-column-with-power-query
VIDEO CHAPTERS ๐บ
0:00 - Video Start
5:00 - Start of Livestream
LET'S CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ๐
-- twitter.com/HavensBI
-- linkedin.com/in/reidhavens
-- youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE ๐
-- havens-consulting.creator-spring.com
HAVENS CONSULTING PAGES ๐
Home Page -- havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Blog -- havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Blog Files -- havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Files & Templates -- havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Consulting Services -- havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Online Course -- havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
Contact & Support -- havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=fZofUPn9TiM
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #workoutwednesdays #workoutwednesday






![Demystifying [DAX] Evaluation Context (with Brian Grant)
โ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, bit-sized sub-formulas; 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 sub-formulas 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 isnt 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 https://www.linkedin.com/in/brian-james-grant
YouTube https://www.youtube.com/@SkypointCloud
LETS CONNECT! ๐ง๐ฝโ๐คโ๐ง๐ฝ๐
https://twitter.com/HavensBI
https://www.linkedin.com/in/reidhavens
https://www.youtube.com/c/HavensConsulting
CHECK OUT OUR MERCH STORE ๐
https://havens-consulting.creator-spring.com/
HAVENS CONSULTING PAGES ๐
Home Page http://www.havensconsulting.net/?utm_source=youtube-hc&utm_medium=video&utm_campaign=hs3T2YF0ewg
Blog http://www.havensconsulting.net/blog-and-media?utm_source=youtube-hc&utm_medium=video&utm_campaign=hs3T2YF0ewg
Blog Files http://www.havensconsulting.net/blog-files?utm_source=youtube-hc&utm_medium=video&utm_campaign=hs3T2YF0ewg
Files & Templates http://www.havensconsulting.net/files-and-templates?utm_source=youtube-hc&utm_medium=video&utm_campaign=hs3T2YF0ewg
Consulting Services http://www.havensconsulting.net/consulting-services?utm_source=youtube-hc&utm_medium=video&utm_campaign=hs3T2YF0ewg
Online Course https://www.havensconsulting.net/online-courses?utm_source=youtube-hc&utm_medium=video&utm_campaign=hs3T2YF0ewg
Contact & Support http://www.havensconsulting.net/contact-and-support?utm_source=youtube-hc&utm_medium=video&utm_campaign=hs3T2YF0ewg
EMAIL US AT ๐ง
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #excel #powerapps #datavisualization #dashboard #bi #analytics #dax #powerquery #onelake #lakehouse #fabric #datawarehouse #evaluationcontext #filters Demystifying [DAX] Evaluation Context (with Brian Grant)](https://i.ytimg.com/vi/hs3T2YF0ewg/mqdefault.jpg)



