Data modelling and DAX
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
How to dynamically measure distance in Power BI