Data modelling and DAX
This is not so much a DAX tip, rather something you might consider if you want to speed up the performance of any Direct Query (DQ) model you manage in Power BI or Analysis Services. The simple tip is to set relationships to use INNER JOIN rather than LEFT OUTER JOIN in the model. Once … Continue reading Tip to speed up Direct Query
Did you know, in some cases, it is possible to add columns to your model to speed up the DAX used behind visuals to make them as much as 100 times faster? The PBIX helper file for this article can be downloaded here. I have come across this scenario a few times recently, so thought … Continue reading Speed up Power BI reports using columns
I read a quote somewhere along the lines of… If you are trying to solve a problem with regular expressions… you now have two problems This seems a little harsh for a useful tool that has been with us for what seems a very long time. Plenty of languages offer support for RegEx string searching … Continue reading Power BI and Regular Expressions
How to dynamically measure distance in Power BI