Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Could someone suggest me a query to display top 10 customer names based on employee head count.
Solved! Go to Solution.
@RashmitaR If you dont' want to go down DAX way, you can use Sorty by option of visual to sort by employee head count. This will give you them in order but won't restrict it to just 10 but you can clearly make out top 10.
TOPN(10,employee,employee[employee_head_count],DESC)
Here is a query that does that. Basically, select the drop down for the column, Sort Descending and then Keep Rows, 10.
let Source = Csv.Document(File.Contents("C:\temp\powerbi\dates.csv"),[Delimiter=",", Columns=4, Encoding=1252, QuoteStyle=QuoteStyle.None]), #"Promoted Headers" = Table.PromoteHeaders(Source), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Value", Int64.Type}, {"Value2", Int64.Type}, {"Value3", Int64.Type}}), #"Sorted Rows" = Table.Sort(#"Changed Type",{{"Value3", Order.Descending}}), #"Kept First Rows" = Table.FirstN(#"Sorted Rows",10) in #"Kept First Rows"
@RashmitaR If you dont' want to go down DAX way, you can use Sorty by option of visual to sort by employee head count. This will give you them in order but won't restrict it to just 10 but you can clearly make out top 10.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
101 | |
87 | |
72 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |