Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
127 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |