Power BI table visual to get only latest date value

[mehaboob557]

I am very new to Power BI. I have connected mysql database to get data. Am doing search in one filter , based on the searched customer, it will show up the data in table visual. But, i stuck to show only the latest date data of a category.

If you see in the above image, there are two initial proposal rows. But, i need only one row of initial proposal category which can be differentiate by the date modified column.

to be more clear --> category Id and date_modified are from table1 and inserted_prefix from table two.

Please suggest me how can i get only the latest data of each category by using measure or any other way.

Thanks a ton in advance.

[v-sihou-msft]

@mehaboob557

You just need to click on the date fields, summarize the date into "Latest".

Regards,

[mehaboob557]

Thank you @v-sihou-msft for the answer. I tried as you suggested. But, i am getting 2 initial proposlas still

[v-sihou-msft]

@mehaboob557

Please remove the "Inserted Prefix" column first, set the "Latest" aggregation on Date field, then add "Inserted Prefix" back to see if it works. 

Regards,

[mehaboob557]

@v-sihou-msft i removed prefix colum ... it Worked fine as you expected.

But, when i add prefix column again... again two intial proposals were in action 😞

[mehaboob557 · Accepted solution]

I Changed  as @v-sihou-msft suggested to make date_modified to latest and the prefix url of data selecting LAST in filters. It was then worked fine. 🙂

Thanks a lot @v-sihou-msft