Search for duplicate and take the latest data out of it

[unknown_anony]

Hello All,
I am trying a logic in ppower bi, below there is a screenshot of my requirement,
It is needed for my project

How will i consider duplicates of both the columns and also consider the latest date(Blue highlighted part) of the same ID but different requst no and get the sum of the values?

All Advices are welcomed.

[Anonymous · Accepted solution]

Hi,@unknown_anony Hello,@amitchandak ,thanks for your concern about this issue.
And I would like to share some additional solutions below

According to your description, you want to achieve something like this in power bi:

Flag Submitted Time records that have the same ID but different Request No's.
like this:

If my understanding is correct, you can refer to my test below

My original data is as follows: (I added an “index” column to prevent Power BI from automatically aggregating duplicate data)

By creating a measure and filtering each row of data in the visual, you can filter the result

I have created three measures

Here is the Dax code:

M_1 = 
CALCULATE(COUNT('Table'[Request No]),FILTER(ALL('Table'),'Table'[ID]=MAX('Table'[ID])&&'Table'[Request No]=MAX('Table'[Request No])))

M_2 = 
CALCULATE(COUNT('Table'[ID]),FILTER(ALL('Table'),'Table'[ID]=MAX('Table'[ID])))

M_result = 
IF([M_1]=1 && [M_2]>1,
1,0)

Here is the result：

Set the background color of the [ID], [Request No], [Submitted Time] columns according to the results of the three measures.
like this:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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

[unknown_anony]

Thank you,
much appreaciated for your help

[unknown_anony]

@amitchandak thank you but this did not help 

i have shared the real data, The SFDC column have duplicate, i have to check whther the request number is same or not for same sfdc number, if the request  is different i have to consider the latest submit date among them given in the screenshot, is it possible to achieve that?
need some quick help, very urgent for my work.

[amitchandak]

@unknown_anony , refer if these two blogs, how to get latest data can help

https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0

https://amitchandak.medium.com/power-bi-get-the-sum-of-the-last-latest-value-of-a-category-f1c839ee8...