Deprecated: Creation of dynamic property ternplugin\youtube_video::$post is deprecated in /home1/cassanoc/public_html/bonbonsguide.com/wp/wp-content/plugins/automatic-video-posts/vendor/ternstyle/plugin/src/class/youtube_video.php on line 64

How To Create Dynamic Tables In Power BI Using RANKX

Posted on by Annie D

In this tutorial, Sam runs through how to create a dynamic table that only shows the top results across a range of measures. You can do this using a combination of DAX formula including the RANKX function. This is great ranking technique for a number of analytical scenarios in Power BI.

*****Video Details*****
00:00 Introduction
01:00 The goal
01:41 Profit growth YOY
03:40 Sales YOY
04:26 Margin growth YOY

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – www.enterprisedna.co/power-bi-resources
Enterprise DNA On-Demand – app.enterprisedna.co
Enterprise DNA Subscription – app.enterprisedna.co/pricing
Enterprise DNA Events – www.enterprisedna.co/events

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #RANKX

Further Help

I offer limited consulting services to potentially assist you with data challenges, whether it's designing a complex Excel formula, writing a macro or building a whole new process for data capture, modeling and analysis.  Contact me if you have a need.

Enterprise DNAMon, January 23, 2023 3:36pm