Measure to Show Previously Used PO Number

[Anonymous]

Hi Experts

I need a calculated column to show instants where the PO Number has been previously used in the past based on date and the Order value is the same (as shown below). End result to show a new column "Duplicated Entry"

PO ID	PO Number	Order Value	Date	Match
30562	0000039	23	16/12/2021	0
78981	0000039	23	18/02/2022	1

[ribisht17 · Accepted solution]

@Anonymous 

Step 1: ///Get me the PO numbers having the duplicate values

Count Rows for PO= CALCULATE(COUNTROWS(Match),FILTER(all(Match),Match[PO Number]=max(Match[PO Number])&& Match[Order Value]=MAX(Match[Order Value])))

Step2 Minimum Date for any PO (Group by PO)

Min Date for PO = CALCULATE(MIN(Match[Date]),FILTER(all(Match),Match[PO Number]=max(Match[PO Number])))

Step3

Final Solution = if(Match[Count Rows for PO]>=2 && max(Match[Date]) > Match[Min Date for PO],"Matched","")

Regards,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users