Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Thank you @v-sihou-msft for the answer. I tried as you suggested. But, i am getting 2 initial proposlas still
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,
@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 😞
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |