Forum Discussion
Check for duplicate values within 2 months from the data entry system
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.
6 Replies
Please explain what you mean by "duplicate numbers". Why would 2019-03-02 be a No ?
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).
It feels like your sample data is missing an important column. Please clarify.
It's an error. I took a screenshot of the excel cell's formula. Its value is "Yes."
2019-03-02 says "No"
