Data modelling and DAX
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
Introduction For this blog, I look at a method to take some text in the form of a horizontal sentence and use DAX to pivot the text into a vertical list of words. The PBIX file for this exercise can is available here. There is no current native function in DAX that can take a … Continue reading DAX : Pivot Text into a List of Words
I wrote a blog back in 2017 on how to better organise your measures in Power BI. One thing that bothered me at the time was I wasn’t able to give the measure table the one name I truly wanted. The perfect name for a measure table is, of course, Measures. Unfortunately, this is a … Continue reading A measure table called “Measures”
I received an email recently asking for help with an interesting DAX question. The person was trying to get a DAX query working using the undocumented TOPNSKIP function to return a table of data that didn’t include the first N rows. The function syntax is as follows : TOPNSKIP ( <Rows>, <Skip>, <Table> [, <OrderByExpression> … Continue reading TopNSkip Alternative