- DAX “Filter Context” Explained11th January 2021Do your DAX measures return interesting values but not the numbers you want? If the answer is yes, and it happens to all of us, then the problem probably lies with the filter context in which the measures have been calculated and the fact that you...
- Join our mailing list to get “The Concise Guide to DAX” pdf21st December 2020“ Why does the world need another DAX book ?” was my first question to Alison when she told me she’d written guide to the DAX language in Power BI. “...
- How DAX Treats Nulls & Zeros12th November 2020In DAX there is a special way to identify null or empty values and that’s by using a value called “blank”. In order to return blank values, we can use...
- All our courses are now available as Live Online Training29th April 2020All our Courses are now available as “ Live Online Training“, here’s what you need to know. In a “Social Distancing” world we can’t gather together in...
- Live Online Power BI Training from Burningsuit8th April 2020We have many years’ experience of training people how to use Microsoft Power BI. Up to now our training has all been face-to-face, either as open...
- Power BI Conditional Formatting16th March 2020I thought this would be an easy blog. Not much to say about using Power BI’s Conditional Formatting. All it does is make visuals look more appealing...
- Categorising Measures into Numeric Ranges or “Bins”22nd January 2020We’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...