Category: Power BI

Calculating Average in Power BI: Isolating Weekday or Weekend Results Using DAX

Calculating an average in Power BI can be done in many ways to give you precise information for your business reports. However, sometimes calculating average sales per day may not be enough. You might run into a scenario where you only sell during weekdays. If you run an averaging pattern in Power BI and you

Continue reading

Time Intelligence In Power BI: How to Calculate The Number of Transactions Made in the Last N Days

Sometimes when analyzing your Power BI reports, you may want to know how many transactions have occurred over a particular period of time. In this blog post, I’ll show you exactly how to calculate transactions within a given period of days using time intelligence in Power BI.  This post will cover a high quality piece

Continue reading

Using The ALL Function In Power BI For High Quality Insights

This blog post will show you how to use the ALL function in Power BI to effectively showcase unique insights and differentials in your numbers. We’re going to dive into the average order size for the sales we may be making across a variety of different products. This tutorial will also show you how to

Continue reading

Create A New Table In Power BI: How To Implement Budgets & Forecasts Automatically Using DAX

In this blog post, I’m going to show you how you can create a new table in Power BI that is purely based on historical information and complete it in an automatic way. When you create budgets and forecasts sometimes you may have to go through a very comprehensive process. I’m going to showcase a

Continue reading

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