Comparing value in to rows in same table

[Anonymous]

EID	Date	Opening Balance	Closing Balance
123	3/14/2019	180	200
123	4/10/2019	200	220
123	4/15/2019	220	300
123	5/17/2019	200	310
111	4/14/2019	140	123
222	4/14/2019	234	345

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.

[amitchandak · Accepted solution]

Check the attached solution after signature