Forum Discussion

pawelj795's avatar
pawelj795
Post Prodigy
5 years ago
Solved

Mark rows with the latest value

Hi, I have a data table like below.   Now, I want to mark rows, which meet these conditions: They contains duplicate values in both columns at the same time: parent_product_tmpl_id, produc...
Need Help
Show and Tell
Tips and Tricks
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi pawelj795 ,

     

    Please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Super User
5 years ago

pawelj795 , You can create a new column like

 

New column =
var _max = maxx(filter(Table, [parent_product_tmpl_id] = earlier([parent_product_tmpl_id]) && [product_tmpl_id] = earlier([product_tmpl_id])),[create_date])
return
if([create_date] =_max , 1, 0)