Evaluation contexts in Power BI DAX
I was in Seattle, USA in the last week of July participating in the Microsoft Business Applications Summit (MBAS). I love attending conferences like this and it was a privilege to present on a few topics over 3 days. One of the presentations I gave was on the topic “Evaluation contexts in Power BI/DAX“.
For those who missed the session, the recording is available now https://www.microsoft.com/en-us/businessapplicationssummit/video/BAS2018-119.
DAX as a Query Language
As part of my visit to the USA, I was invited to attend the Pacific Northwest Power BI Symposium organised by Portland user group. In the symposium I presented on the topic “DAX as a Query Language“.
In this session, I introduced the topic and showed how one can use DAX Studio to connect to a data model. Once connected, DAX studio can be used to write queries over the tabular data model to start to interrogate the data itself (as opposed to simply aggregating the values into a pivot table or a Power BI report). The learning can then be used to write more complex DAX measures or alternatively it can be used to extract tabular data directly into a table for further analysis.
The session was live-streamed on YouTube, but for those who missed to view the presentation, it is available here.