Display only latest date row of each category RRS feed

  • Question

  • Hello,

    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.

    I a m unable to add images and links here. i am just giving link with http .. u can see images there

    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.

    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/PQL/DAr any other way.

    Thanks a ton in advance.

    Wednesday, August 2, 2017 6:13 AM