Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Check the attached solution after signature
Check the attached solution after signature
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |