Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |