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 Everyone,
I looked onto the forum but didn't find exactly what I'm trying to achieve.
I have a long table of intervention done by technicians with date, client reference etc.
Each intervention has a price.
I have created the measure that allows me to sum the prices and divide it by the number of days where the technician has made at least 1 intervention.
However, the last step for me is to count only the highest price by day by client reference. Indeed, when a technician goes to 1 client and does 2 or 3 interventions at the same time, I want to count only the highest price in my calculation.
Solved! Go to Solution.
Hi @SuperSayan,
Could post your table structures(including the measures you're using) with some sample/mock data, and the expected result against it? So that we can better assist on this issue.
Regards
Hi,
I don't understand why but this post has been duplicated.
The other version of the post was closed after the answer was given, see below.
http://community.powerbi.com/t5/Desktop/sum-of-max-values-by-date-client/m-p/247337
I therefore close this thread as it has been solved somewhere else.
Hi @SuperSayan,
Could post your table structures(including the measures you're using) with some sample/mock data, and the expected result against it? So that we can better assist on this issue.
Regards
Hi,
I don't understand why but this post has been duplicated.
The other version of the post was closed after the answer was given, see below.
http://community.powerbi.com/t5/Desktop/sum-of-max-values-by-date-client/m-p/247337
I therefore close this thread as it has been solved somewhere else.
Hi,
Share the link from where we can download your file. Also, show the expected result.
Your post is unclear.
If the data you provide is the starting data set - please state an example of the result you seek (not just a description/definition).
If the data you provide is the result you seek - please provide a sample of the starting data set.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |