Loading…
Phoenix Power Platform World Tour
Attending this event?
Thursday, December 5 • 9:00am - 10:00am
DAX and Filter Context - Seeing the right data

Sign up or log in to save this to your schedule and see who's attending!

Log in to leave feedback.
This session will demystify DAX Filter Context, which determines what portion of your data model a calculation has access to and how you can ensure you have the right data and an accurate result. We'll start with some groundwork on the key concepts involved with DAX, the data formula language used by Power BI and Excel's PowerPivot, including the difference between Row and Filter context, and when you use CALCULATE. We'll spend the bulk of the session with examples of how filters are working, how to modify filters to act on subsets of supersets of your data, and how you can use virtual tables and variables to modify your context. If time allows, we can slip in some DAX editor hotkeys everyone can use whenever they edit DAX to save themselves time and aggravation!

Speakers

Thursday December 5, 2019 9:00am - 10:00am
Canyon C

Attendees (13)