Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Hello,
I am trying to find a measure that will look for the highest sales record for a location and return thant # and the date it made the record. I need this for each location.
When I am researching, a lot of the solutions use something like:
CALCULATE(SUM('Table'[Sale amount]
but my sales amount is a measure and not a column, so it's not working well with the sum function.
Solved! Go to Solution.
I was able to get it using this link
https://p3adaptive.com/2012/06/finding-the-top-selling-date-product-etc/
I was able to get it using this link
https://p3adaptive.com/2012/06/finding-the-top-selling-date-product-etc/
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 5 | |
| 4 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 12 | |
| 11 | |
| 9 | |
| 8 |