I have a task bringing me into confusion.
Fact table with agreement net changes is given.
What I need is to calculate balance of each agreement and sum them up.
1. Could you assist me how to optimize SUMX, if number of agreements is about 100k and only part of them can be in current scope (Customer, Company etc)?
2. Is there efficient way to create precalculated Balances Fact table by Date,Counterparty and Agreement via Power Query or DAX?
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!