Category: DAX

Calculation Groups to the Rescue!

o set the stage, I need you to travel back in time with me a bit. The year was 2019, and none of us had ever heard of COVID-19…those were simpler times.

Written by on March 31, 2021

Reducing DSO using Power Pivot

One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens.

Written by on November 13, 2018

Using Dax to create a KPI

Not long after I started my career in FP&A, I became interested in KPI development. It’s a natural progression I think: you get the budgeting, forecasting, and reporting under control, and then you begin to dig a little deeper.

Written by on September 4, 2018