Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pawelj795
Post Prodigy
Post Prodigy

Mark rows with the latest value

Hi,
I have a data table like below.

 

pawelj795_1-1617024980419.png
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, product_tmpl_id
    (in my screenshot it will be ID: 290256, 153653)
  • Next, for rows, which meet the above condition, select the row with the latest date in a column create_date
    (in my screenshot it will be ID: 290256)
  • Furthermore, these marks must be created in a column, not a measure


Sample file:

https://drive.google.com/file/d/1JRVwaAN-WDW0xzo-WEAu9vUZM7yygyCW/view?usp=sharing

 

If something is not clear for you, please ask and I kindly respond.

Thanks in advance!

1 ACCEPTED SOLUTION
v-lionel-msft
Community Support
Community Support

Hi @pawelj795 ,

 

Please refer to my .pbix file.

v-lionel-msft_0-1617246549558.png

 

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.

 

View solution in original post

7 REPLIES 7
v-lionel-msft
Community Support
Community Support

Hi @pawelj795 ,

 

Please refer to my .pbix file.

v-lionel-msft_0-1617246549558.png

 

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.

 

ryan_mayu
Super User
Super User

@pawelj795 

please check the attachment to see if this is what you want





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@ryan_mayu 
@amitchandak 

Sorry, but both of your answers are not working properly.

My goal is to filter out rows that meet all of these conditions.
In your answers, it works fine for duplicates but simultaneously it filters out also some rows with distinct values.
This column must work for the whole data table.

Moreover, the answer must be created in one column, not divided by 2 columns.

.

amitchandak
Super User
Super User

@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)

 

 

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

pawelj795_0-1617027287781.png


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

 

@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)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors