From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2024)

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Create semi-additive measures

Create semi-additive measures - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press (2024)

Start my 1-month free trial Buy for my team

Create semi-additive measures

“

- [Instructor] Okay, so in this sub-lesson we're going to talk about how to create semi-additive measures. But first off, what are semi-additive measures? Semi-additive measures can be summed across some, but not all dimensions. Balance amounts are common semi-additive facts and they're additive across all dimensions except time. And bank balances and inventory accounts are common examples where semi-additive measures are needed. Some common DAX function that support semi-additive measures are the LASTDATE function, FIRSTDATE, LASTNONBLANK, FIRSTNONBLANK, OPENINGBALANCEMONTH and CLOSINGBALANCEMONTH. So, let's go to the Power BI desktop and take a look. Okay, so I am on the Power BI desktop here. And what I want to point out first is I have an inventory table here, which basically has a date and a specific inventory level for that day. So, let's take a look at July 1st here and we have the balance of 100 units. And if we go all the way through each one of these different days here, all…

Contents