Walk-through

DAX Date Table

There are a lot of different Date tables out there, and this is mine! This one features things I add in many of my reports, which is a...

943 views

Report overlay to highlight report features

When I show a report to someone, I find myself pointing to parts of the report and explaining what they do, here I add an overlay to do it.

Buttons to highlight a selected measure!

Use buttons to highlight which selected measure is being used!

1,066 views0 comments

Working with DateID in Direct Query and Incremental Refresh

Scenarios when using DateTime to limit data and maintain query folding can be done with DateIDs! Two scenarios are (1) rolling x days of dat

Creating a slicer panel!

Many of my reports feature the slicer panel that hide/show on via a button.

Let's create a data model!

Tabular data modeling is key to making a report, and can be daunting at first. I'll show you how I approach making a tabular data model....