Get the YTD of the same period last year
I was looking at my blog stats and found that some of the most popular posts are almost 10 years old (yes really). Those topics... Read more
Category: DAX
Use more variables in DAX to simplify your life
Today I ran across a pretty straightforward DAX challenge that is made so much simpler thanks to variables. So I decided to share it. Remember... Read more
On demand webinar: Strengthen Your Data Modeling Skills with Power BI
I recently did this webinar for Power BI in the studios in Redmond. The webinar goes into details on the data model with Power Query,... Read more
Time intelligence solved with modelling and crossfilter instead of DAX measures
A while ago I came across this interesting time intelligence solution that doesn’t use DAX measures to do time intelligence but rather solves it through... Read more
Use IsInScope to get the right hierarchy level in DAX
In the November release of Power BI desktop we introduced a new DAX expression that is really great. Working with hierarchies in DAX have always... Read more
Creating a Hyperlink with filters through DAX
Thanks to two recent Power BI features it now possible to generate a link on the fly using DAX to go to a new report... Read more
Showing KPI’s in a table or Matrix with Power BI
Got a question today on how we can do KPI’s in the matrix or table with Power BI, just like we can with PowerPivot through... Read more
Using variables to split up your calculations
Got a DAX question recently that I solved using variables. When I walked them through the solution someone exclaimed “I didn’t know you can do... Read more