Tag: CALCULATE function

Calculate Percentage In Power BI In Hierarchical Form

Calculate Percentage In Power BI In Hierarchical Form - Enterprise DNA

You might encounter a requirement where you’ll need to display the ratio percentage of a particular level in your data against a parent level. Many might find this to be a tricky task as there is no straightforward function to achieve this result. In this tutorial, I am going to demonstrate how you can calculate

Continue reading

Time Intelligence In DAX: How To Dynamically Select Starting Period

Power BI Dynamically Select Starting Period

In this blog post, we will deal with some troublesome issues in time intelligence, particularly those issues caused by week granularity and the troubles that can be caused by the irregular number of weeks in a year. We’ll use offsets to come up with accurate time intelligence in DAX. We have an interesting scenario for

Continue reading

Expanded Tables In Power BI

working with expanded tables

In this tutorial, we are going to take a look at a very specific scenario that I’m sure all of you have already encountered while working with DAX – the expanded table. Expanded tables can mess up your calculation if you don’t know how they actually work. You can watch the full video of this

Continue reading

Power BI Tip: How To Compare First N Business Days

For this post, I would like to talk about a recent Power BI tip that I came up with for a member of the Enterprise DNA forum. The question dealt with a useful pattern in terms of looking at the first N business days or first N billable days of a given month versus the

Continue reading

CALCULATE Function – How It Can Affect Your Calculations On Power BI

In this tutorial, I want to show you what the CALCULATE function can do through a few examples. CALCULATE is one of the most frequently used functions in Power BI. It dictates the context being applied to any measure and removes any existing filters in place. Using CALCULATE Function For Total Sales To truly understand

Continue reading