Kane SnyderHi all,Sam Fischer was nice enough to let me know that using the DAX Function PERCENTILEX.INC is probably a better way to find the top or bottom…Apr 1, 2021Apr 1, 2021
Kane SnyderRolling Date Period Slicers With Calculation GroupsIt’s been a while since I posted anything about my favourite topic calculation groups so I thought I would share this quite simple but…Apr 1, 20211Apr 1, 20211
Kane SnyderDynamic Chart Labels with Calculation GroupsA really useful application for calculation groups is giving users the ability to control labels and number formats in charts and reports…Jan 6, 20218Jan 6, 20218
Kane SnyderAllowing users to choose any two different metrics to compare in a single chart with calculation…This is a relatively straightforward thing to achieve in a report using calculation groups but nonetheless, very useful and a good…Dec 28, 2020Dec 28, 2020
Kane SnyderFun with Calculation GroupsI believe there are many Power BI users who still only only consider the classic example of Time Intelligence in regards to calculation…Dec 14, 2020Dec 14, 2020
Kane SnyderDynamic Segmentation with Calculation GroupsOne of my favourite things about calculation groups is the ability to use calculation items as filters. In my last blog post I looked at…Nov 30, 2020Nov 30, 2020
Kane SnyderCombining calculation groups in Power BI to create powerful reportsI recently posted on Twitter about combining calculation groups to create a tooltip that works for any measure value in a matrix. The idea…Nov 14, 20202Nov 14, 20202
