Forum Discussion
Calculate Identical Values from separate Columns together
Hello Everyone :))
I have a Dataset that looks pretty much like this. It documents the cash transfered between companies. The Cash transfered from a company to the other should also be available in reverse (Nike sent Huawei 500€ so Huawei should receive 500€).
My goal is to have a measure or Column for a large Dataset that calculates the difference between these amounts, so i can find out which transactions are faulty. (500 - 500 = 0)
I have been struggling with this for a couple of days, and would be very gratefull to anyone who can help ❤️
Renoplos
This task involves an ETL process, and I've implemented a Power Query solution. The approach includes creating two referenced tables—one for sent amounts and the other for received amounts. Subsequently, I merged these tables and computed the difference. Please review the attached file for details.
2 Replies
- Fowmy
Super User
Renoplos
This task involves an ETL process, and I've implemented a Power Query solution. The approach includes creating two referenced tables—one for sent amounts and the other for received amounts. Subsequently, I merged these tables and computed the difference. Please review the attached file for details.
