Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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/