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.
Hi All,
Hope everyone's good.
I need to create a measure to get the top 3 vendors with most appearances in each month in the "top highest sum amount by month". I need a view where I can monitor these vendors that are consistent in the top 3 each month. This is going to be helpful so I can flag these vendors and report.
I have 4 columns:
Date column: January to April 2023
Vendor name column: A, B, C, D, E
Amount column
Discount column: Yes or No (Choose Yes only)
FYI- Please filter Discount column with "Yes" and then refer to the amount.
Perhaps something like this:
Here's the sample pbix if you need it. Thank you
Solved! Go to Solution.
Top 3 =
var a = SUMMARIZE(Discount,[Vendor name],"am",sum(Discount[Amount]))
return if(hasonevalue(Discount[Vendor name]),BLANK(),CONCATENATEX(topn(3,a,[am],DESC),[Vendor name],",",[am],DESC))
see attached
what's the expected output based on the sample data you provided?
Proud to be a Super User!
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 |
---|---|
112 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |