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.
Dear experts,
Could you please help me with the following question?
We have a PowerBI model that works fine for all calculations except for measures that use XIRR function.
The XIRR function seems to be working only with relatively small number of members in a dimension.
For example if I want to calculate XIRR by company dimension (we have 300 companies in the portfolio), then the calculation fails.
If we limit the number of companies to let's say 30, then the calculation works fine for each company.
Is there any limits for XIRR function in terms of number of members in a dimension that you want to calculate the XIRR by?
Is it possible to fix this issue somehow? Do we need to add more RAM or more CPU power to be bale to calculate XIRR for all 300 companies in our portfolio?
Thanks,
Solved! Go to Solution.
The issue with XIRR function was resolved by SQL Server RTM CU8 and SQL Server SP1 CU6 cummulative updates.
The issue with XIRR function was resolved by SQL Server RTM CU8 and SQL Server SP1 CU6 cummulative updates.
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 |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |