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. You may watch the full video of this tutorial at the bottom of this blog. This discussion is based on a question in the Enterprise DNA support forum. A Power

Continue reading

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

calculate a year-to-date (ytd) monthly moving average in power bi post image

This is a deep dive tutorial on how to calculate the Year-To-Date Cumulative and Monthly Moving Average in Power BI. You may watch the full video of this tutorial at the bottom of this blog. The example used in this tutorial is from a question in the Enterprise DNA Support Forum. Calculation of Months Aside

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. You may watch the full video of this tutorial at the bottom of this blog. To set the date range for the calculation of monthly average results, we will be using a date slicer. A Power

Continue reading