Create a calculate table with maximum date and maximum value

[Pbiuserr]

please delete this thread and option for solution

[Pbiuserr · Accepted solution]

Sorry, I've too quick assumed I did good calculation, please remove this solution

[ribisht17]

@Pbiuserr 

This should work

Step1

Max Date per ID= calculate(max(date),allexcept(table,ID))

Step2

Max Val per ID=calculate(max(Value),allexcept(table,ID))

Step3

IF(AND(Max Date per ID=Date,Max Val per ID-Value),true(),false()) //drag this to Filter and select true

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users 

[Pbiuserr]

Hey. Would it work on calculate table as well?

[ribisht17]

Not a great way to seek help, community posts are for everyone , you have made it look awkward now.At-least you would have pasted your solution /or accpeted mine as the solution if you made use of the same