Hi All!
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?
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
