XIRR function error in a PowerBI model

[ssolovei]

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,

[v-chuncz-msft]

@ssolovei,

I see you already have submitted a ticket here, so stay tuned.

[ssolovei · Accepted solution]

The issue with XIRR function was resolved by SQL Server RTM CU8 and SQL Server SP1 CU6 cummulative updates.