BI as Business Insight

Proving that what you do has real impact.

Grouping in Ranges/Bands

Scenario In my previous post “Ranges as Filters for Dates” I covered a way to group on ranges of months that we could use in selections. In this post I’ll share a way to simplify the measures using DAX’s SWITCH function, and also apply it to other cases. HowTo In the previous post we used… Read more

Ranges as Filters for Dates

Scenario We may have data across months, and we’d like to, at times, focus on the next 3 months, the following quarter, or the first 6 months… or similar, i.e. how many people between 20-30 years old, or 30-40, etc. How do we define these ranges, and how can we visualize them? HowTo Let’s say… Read more