Writing a DAX query using TOPN

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=tgL7D3JTa_E

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...

#############################

New on site