Forum Discussion

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost 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
Icon for Super User rankSuper 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)

 

 

pawelj795's avatar
pawelj795
Icon for Post Prodigy rankPost Prodigy
5 years ago

amitchandak 
Thanks for your response.
Unfortunately, your column doesn't work.


My main goal is to filter out rows, which are duplicates with the earliest values, however I want to keep the other rows, which don't meet the first condition

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    pawelj795 , try Id in place of date

     

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