Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Writing a DAX query using TOPN

SQLBI
120K subscribers
35K views 4 years ago
Learn how to write a DAX query using TOPN to display the first elements in individual rows, grouping the remaining elements in a single "Other" row. The goal of the video is to show how to write a DAX query from scratch, reaching the final goal in small steps. The query shown in this video can be useful to build tables in Excel (not PivoTables), report in Paginated Reports, and calculated tables in Power BI. You can test the code using DAX Studio connected to the Power BI file available in this article, which has also a different approach based on measures that work in Power BI reports: https://sql.bi/245527?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin... ...more
...more
Writing a DAX query using TOPN
1KLikes
35,858Views
2020Nov 3
Learn how to write a DAX query using TOPN to display the first elements in individual rows, grouping the remaining elements in a single "Other" row. The goal of the video is to show how to write a DAX query from scratch, reaching the final goal in small steps. The query shown in this video can be useful to build tables in Excel (not PivoTables), report in Paginated Reports, and calculated tables in Power BI. You can test the code using DAX Studio connected to the Power BI file available in this article, which has also a different approach based on measures that work in Power BI reports: https://sql.bi/245527?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

Follow along using the transcript.

SQLBI

120K subscribers