Category: DAX

The DATEADD Function: The Best And Most Versatile Time Intelligence Function in Power BI

If you need a Power BI time intelligence function that you can use to generate time comparisons over a range of different time frames, then the DATEADD function is the one you’re looking for. This, by far, is my go-to time intelligence function in DAX at the moment. After going through this post and the

Continue reading

How To Harvest Power BI Slicer Selections To Use Within Other Measures

How To Harvest Power BI Slicer Selections To Use Within Other Measures

What I’m looking to achieved here is to showcase how you can create a table on the fly in Power BI, then place a column of that table into a slicer to then extract or ‘harvest’ a value inside a measure. Then be able to insert this into an existing calculation or another measure that

Continue reading

First Ever Power BI & DAX Master Class Event From Enterprise DNA

Announcement--Power-BI-&-DAX-Master-Class

Next week, we will be running our first ever Power BI & DAX Master Class event. This will be a virtual event held on Enterprise DNA TV. This 4-day event is a new Power BI learning experience that we plan to put on every quarter. You can learn more about the workshop sessions and register

Continue reading

How To Work With Multiple Dates In Power BI

As soon as you start developing a few Power BI models, you’ll very likely run into a problem where you have two dates in your fact table and you can’t place two relationships between your date table and the other table. You might even have multiple dates, like entered date, ordered date, invoiced date, shipped

Continue reading

Measure Averages Per Day Using AVERAGEX With DAX

Measure Averages Per Day Using AVERAGEX With DAX

Here I’m going to show you how to use the function AVERAGEX with DAX in Power BI. By learning and understanding how to use this function, you very quickly open up a range of analysis that can be incredibly insightful and valuable. Maybe you want to work out the average sales you make per day,

Continue reading