Filter latest date of consent by channel

[madmanmark198]

Hi there

I have a consent table which lists all of my customers consent for marketing.  See screenshot below.  I want to be able to filter this list down to the very latest latest "Email" consent for each customer.  So basically I want a unique row person customer for their latest email consent.

[amitchandak · Accepted solution]

@madmanmark198 ,

Latest
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...

[madmanmark198]

Thank you for sending me the links.  Unfortuantly I am quite amature at this so it would be great if you would be able to explain it in context to my table?  Sorry for the hassle.