TOPN(<Direction>, <offset column>, <OrderBy_Expression>)
Direction: -1 up, 1 down
Orderby: ASC, DESC
About Window functions:
Before jumping into the offset function, lets learn about what window functions are and how they work:
Tutorial with example
Now, lets look at this new function in the video:
Links to the mentioned resources
To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File from the 25 days of DAX Fridays Ed2
« Back to Index
Was this helpful?
Let us know your thoughts...