Dynamic filtering of table visual

[Anonymous]

Hi,

I have a dataset with serveral rows per person and different dates and with several columns with different info. I want to slice dates and only see one row per person and only see the latest data from the rows between the date interval from the slicer. I've tried diffrent ways to get this to work, without any luck and now I'm out of ideas.

I've used "latest" as value on the date in the table and I see the latest post but there's still some duplicates where some of the info have changed, like company or address and so forth. And I understand that these are uniqe rows but I still only want to see one row per person.

I've made some dummydata to show my problem. 

All dates are chosen but I've only used the latest dates in the table and there are 12 uniqe persons but we can see duplicates of Bart and Lisa since Bart has changed site once and Lisa has three different addresses. I only want to se Lisa once with latest address: ABox 1112 and Bart once with latest site: Bolag2 AB. Any suggestions how to solve this, if it's even possible?

Best Regards

Sara

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

Create measures

Measure = CALCULATE(MAX(Sheet3[date]),FILTER(ALLSELECTED(Sheet3),Sheet3[name]=MAX(Sheet3[name])))

Measure 2 = IF(MAX(Sheet3[date])=[Measure],1,0)

Best Regards

Maggie

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

[Anonymous]

That did it! Thank you so much!

Best Regards

Sara