Category: Enterprise DNA

Announcing The Enterprise DNA Submit A Showcase Program

Today we are launching a brand-new program here at Enterprise DNA. We are looking to collaborate with talented Power BI analysts and developers through our new submit a showcase program. What’s the Submit A Showcase Program all about? Enterprise DNA already has an extensive depository of Power BI showcases and projects. You can actually view

Continue reading

Use DAX To Segment & Group Data In Power BI

Using DAX measures to dynamically group data in Power BI is so powerful. You’re building out your data models and creating many different filters and ways to slice your data. This is slightly more advanced today, but I love this type of stuff in Power BI. Remember, these likely don’t exist in your original datasets,

Continue reading

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

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

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