In this blog, I’m going to compare Power BI calculated column and measures, and then cover some of their differences. I’m also going to show you optimal situations where you can use either of them. Creating Calculated Columns I’m going to start by creating a calculated column in Power BI. This is probably what you’re
There is still a lot of confusion about the difference between SUM vs SUMX in Power BI. This is key knowledge that users have to master because both functions can be used across different scenarios, but there are cases where one is more efficient than the other. I’m going to focus on one example here
I’m going to cover some great functions here in Power BI that are very useful across a variety of analytic scenarios. Some of these functions can help us work out the last three customer sales. What I want to show you is how to work out the sales from a specific customer, but by only
I’m going to show you today how to use iterating functions when you’re trying to fix Total issues in Power BI. When I go through the questions posted on the Enterprise DNA support forum for members, I see a lot of people having issues with the Totals they get on their report regardless if they’re
Today, I wanted to cover a unique technique around cumulative totals based on monthly average results in Power BI. To set the date range for the calculation of monthly average results, we will be using a date slicer. A Power BI slicer is an alternative for filtering which narrows the portion of the dataset shown in
