Forum Discussion
Resolver IIIPower BI table visual to get only latest date value
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.
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
5 Replies
v-sihou-msftMicrosoft Employee
- 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
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,