Tag: FILTER STATEMENT

How Many Staff Do We Currently Have – Multiple Dates Logic In Power BI Using DAX

In this tutorial, you’ll learn how to work out the current staff population for multiple dates in Power BI using the COUNTROWS and FILTER function. This discussion is based on a question in the Enterprise DNA support forum. A Power BI user wanted to calculate the number of staff members that have been hired within

Continue reading

Calculate A Year-To-Date (YTD) Monthly Moving Average In Power BI

This is a deep dive tutorial on how to calculate the Year-To-Date Cumulative and Monthly Moving Average in Power BI. The example used in this tutorial is from a question in the Enterprise DNA Support Forum. Aside from working out the Moving Average, we also wanted to show the results in a table with a

Continue reading

Cumulative Totals Based On Monthly Average Results In Power BI

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

Continue reading