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