Got Max Value Correct But Date Corresponding to this is wrong

[Anonymous]

Hi Guys,

I need your guidance, I have a table and in this table i have Id and date and forums I need output like Id Max Forum and date.

But the issue i am facing is Id i got correct max i got correct against that Id but the date correspond to this id and max form is inccorect 

In below picture Id is 221 and Max Forum is 170 but date is wrong date should be 30-07-2021

[v-jingzhang · Accepted solution]

Hi @Anonymous 

From your picture, currently your Date column returns the minimum date of an Id. If I understand it correctly, your purpose is to get the max value for every Id and the corresponding date of that max value, right? You need to create a measure to get the corresponding date and put it into the matrix visual instead. 

Measure

Max Date = 
var _maxForums = MAX('Table'[Forums])
return
CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[Id]),'Table'[Forums]=_maxForums)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[MFelix]

Hi @Anonymous ,

Looking at your data the results are correct, in the image you present the values for 221 don't include the value 30/07/2021 where does this value comes from? is it from another table? Isn't your image complete?

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.