Power BI in Practice Blog Posts

We've often been asked if it's possible to group the results of a DAX measure into numeric ranges. For example, to group a Total Sales measure for each Customer into various numeric ranges, sometimes referred to as "bins". The answer is, yes it is, as you can see from the screenshot below:- In this screenshot, we can see that we have five customers whose Total Sales fall between 150,000 and 199,999 in 2019. How did I do this? Firstly, my… Read More

I had an interesting request from a client recently, they wanted to work out how frequently their customers ordered products. Putting this into "database speak" they wanted to calculate the number of days between customers' transactions. Clearly, in order to do this calculation, I needed to find the transaction date that was before the transaction date sitting in the current row. It occurred to me, that such a calculation could have a more general application; not necessarily just calculating days… Read More