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/...
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.
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.