Forum Discussion

SuperSayan's avatar
SuperSayan
Icon for Resolver I rankResolver I
9 years ago
Solved

sum of max values by date/client

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.

 

 

4 Replies

  • CahabaData's avatar
    CahabaData
    Icon for Memorable Member rankMemorable Member
    9 years ago

    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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    9 years ago

    Hi,

     

    Share the link from where we can download your file.  Also, show the expected result.

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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. :smileyhappy:

     

    Regards