Select Page

Reducing DSO using Power Pivot

Navigating the sea of data One of the many things which amaze me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens. For example, receivables not being paid… This post first appeared...

Techniques With COUNTROWS

I watched a video from Guy in a Cube’s Patrick featuring Marco Russo where they walked through an example using a technique to debug DAX measures using VAR/RETURN – I loved this! https://www.youtube.com/watch?v=9SV2VnYbgg4 The video made me recall another Blog… This...

Automated Testing With Power Query

This is a quick tip on automated testing with Power Query. I loved Nar’s post on Automated Testing using DAX. I especially like the rule of always including controls so that business readers can share responsibility for data quality. For… This post first appeared...