Forum Discussion

Rinto's avatar
Rinto
Regular Visitor
4 years ago

Question about finding max value in dataset

Hi all, i have a question about finding the max value.   My dataset looks like the following: Name Date Time Full Hour Unique key Value Theo 01-01-2020 00:00 00:00 Theo 01-01-2020 ...
v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
4 years ago

Hi, Rinto ;

You could create a measure.

max = CALCULATE(MAX('Table'[Value]),FILTER(ALLSELECTED('Table'),[Unique key]=MAX([Unique key])))

The final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Rinto's avatar
    Rinto
    Regular Visitor
    4 years ago

    Thank you v-yalanwu-msft for your reaction

     

    I am looking for a query with which I can build a new column, because after this new column is created i want to sum up two datastreams to a new unique datacolumn.

    For example Frank and Theo live in the same house (adress). After I have found the max measure for a date and time stamp with the name Frank and the same for Theo. With the next step I want to sum up the max value for Frank and Theo at the exact samen date and time stamp, using a new unique code in which the date and time stamp are used in combination with the adress of there home.

     

    Thanks,

    Rinto