Tag: FILTER

Compare Multiple Metrics Cumulatively In Power BI Using Advanced DAX

I’ve previously showcased how you can compare your actual results versus your budgeted results using advanced DAX. But, what if you also wanted to overlay some time comparison information so you’re comparing your actuals versus budget versus last year? Or perhaps versus last quarter? Or against any other time period you may want to select?

Continue reading

Cumulative Totals Across Averages & Dynamic Date Logic – Advanced DAX

Cumulative Totals Across Averages & Dynamic Date Logic - Advanced DAX

Today I wanted to cover a unique technique around cumulative totals inside of Power BI. Usually, when we are reviewing cumulative totals we are analyzing them over a date or over a month and year. What we are going to do here though, is we’re going to analyze them versus the month. This particular example

Continue reading