If eid is duplicate, check if current date's Opening sale is same as previous date's closing balance. i.e. If we check EID 123 its 14th Mar opening balance 200 should be equls to 10 April closing balance. But when we check if 17th May opening balance is not matching with 15th Apr closing balance. Is there any DAX or method in Power BI we can you to compare such scenarions.