Check for duplicate values within 2 months from the data entry system

[xxx_holic_xxx]

Check for duplicate values within 2 months from the date the data is entered into the system. 
I want to check for duplicate values with the following rule: if date is 1/1/2019 (d/m/y) => "No", 1/3/2019 => "Yes", 2/3/2019 => "No", 1/4/2019 => "Yes". In short, check the duplicate before 59 days (about 2 months) from the current date. In excel, I use this formula IF(COUNTIFS($A$2:A2,">="&(A3-59),$B$2:B2,[@Number],$C$2:C2,"No")>0, "Yes","No") but I can't figure it out in Power BI or SQL. I look forward to receiving the solutions from all of you. Many thanks.

[xxx_holic_xxx]

It's an error. I took a screenshot of the excel cell's formula. Its value is "Yes."

[lbendlin]

2019-03-02 says "No"

[lbendlin]

Please explain what you mean by "duplicate numbers".  Why would 2019-03-02 be a No ?

[xxx_holic_xxx]

Data is considered "New" labeled "No" because it has been more than 2 months (59 days) after the day it was entered into the system (2019/01/01).

[lbendlin]

It feels like your sample data is missing an important column. Please clarify.

[xxx_holic_xxx]

No, the column and data are sufficient. I can solve it in Excel using the aforementioned formula, but I'm at a loss in Power BI and SQL.