Power BI表可视化仅获取最新日期值 [英] Power BI table visual to get only latest date value

问题描述

我对Power BI非常陌生.我已连接mysql数据库以获取数据.在一个过滤器中进行搜索，根据搜索到的客户，它将以表格形式显示数据.但是，我坚持只显示类别的最新日期数据.

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.

更清楚--类别ID和date_modified来自表1，来自表2的insertd_prefix.

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

现在，在下图中.我选择了其他客户.他有3个初始建议和5个初始设计.因此，我只需要一个初始设计和初始提议，即最新日期.

now, in the below image. I selected different customer. he had, 3 initial proposal and 5 initial design. So i need only one initial deign and initial proposal which is latest date.

请建议我如何使用度量或其他方法仅获取每个类别的最新数据.

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

提前感谢一吨.

推荐答案

我有我的要求.

只需短短的一周时间就可以进行数据选择.只需确保使用最新"修改日期即可.insert_prefix在下面的图像中最后选择showin.

Just a small tweek in data selections. just make sure to have date modified with Latest. insert_prefix select last as showin in below images.

这篇关于Power BI表可视化仅获取最新日期值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！