TOPN DAX Function How it works in Power BI Comparison against the top group
Vložit
- čas přidán 25. 05. 2021
- 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:
radacad.com/topn-dax-function...
*******************
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.
RADACAD courses: radacad.academy
Our upcoming courses: learn.radacad.com/events/
Free books and tools for Power BI: radacad.com
Become an academy member: learn.radacad.com/academy/
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
********
#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD - Věda a technologie
Very useful tutorial! Thank you :-)
Good Explanation
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
Did you try the Relative Date slicer?
Where you used conditional formating Dax.
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.