Forum Discussion
xxx_holic_xxx
3 years agoFrequent Visitor
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/...
lbendlin
3 years agoSuper User
It feels like your sample data is missing an important column. Please clarify.
xxx_holic_xxx
3 years agoFrequent Visitor
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.