Show the name of the category based on max value on a particular day

[Anonymous]

Hello Community,

I want to create a measure to get the name of the category that have the max value on a particular day so I have two tables: 

Both table are related by ID_Circuit,

I want the show the presses that have the max value in a particular date.

Based on a date Slicer like this: 

Thank you 

[Ahmedy · Accepted solution]

see attached
https://1drv.ms/u/s!AiUZ0Ws7G26Rhgg7OrGbVA5QKOuK?e=6CwL8k

[ryan_mayu]

could you pls provide the sample data (not the screenshot)? which column does the max value  depend on ?

[Anonymous]

@ryan_mayu Please find the sample data in this link:

https://docs.google.com/spreadsheets/d/1voqlEp1sh_wBmTcL5-yUXvoscoxxfgu4/edit?usp=share_link&ouid=10...

and the column which does the max value  depend on called KWH in the table KWH

Thanks for your help

 

[ryan_mayu]

then how to get the category.

e.g. the screenshot you provided the max value on 2021/10/25 is 943

id_circuit Jour KWh Teq CO2
3518474 25-Oct-21 943 0.08489655

 i can't find the id in another table