TOPN DAX Function How it works in Power BI Comparison against the top group

preview_player
Показать описание
TOPN is a function in DAX that gives you the ability to select the top items from a table based on an expression. In this article and video, I’ll explain how to use the TopN function in DAX either to create a calculated table or to use it in a measure to achieve analysis such as; comparison with the average amount of the top group.
Learn more and download the Power BI file from my blog article here:

*******************

Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.

*******************

********
CONNECT with US!
********

********

#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD
Рекомендации по теме
Комментарии
Автор

dude, this might sound a bit strange but i've seen your face around a few times looking for dax-related stuff and i can't help but feel sorry for how much your face screams "bully me!". i hope you had a nice childhood and that this is all in my head. best wishes, my man.

tasos
Автор

Where you used conditional formating Dax.

venkatareddykummitha
Автор

Hey loved your video, but I have a problem of mine.
I want to make slicer which should show date_range for last 3 months, last 6 months, last 9 months and last 12 months from the date column given. Please help how do I do that?
I tried creating a date_range column using switch and If in Dax but it only shows 2 of them(i.e last 3 months and last 6 months even though I have data for last 9 and 12 months too.
Would love to hear from you! Thanks

shivaniverma