Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi I have these two sets of data in Excel, which return legit IRR. May I know why is it not working in powerbi?
(4.8486) | -4848.58 | 12/31/2020 |
(1,572,650,460) | -15726504.60 | 11/5/2021 |
(12,505,360) | -125053.60 | 1/27/2022 |
(125,238,053) | -1252380.53 | 2/7/2022 |
62,109,350 | 621093.50 | 2/9/2022 |
193,133,568 | 1931335.68 | 2/10/2022 |
37,832,508 | 378325.08 | 2/11/2022 |
16,528,557 | 165285.57 | 2/14/2022 |
(2,116) | -21.16 | 2/15/2022 |
(1,033,805) | -10338.05 | 2/18/2022 |
(2,916,434,129) | -29164341.29 | 2/23/2022 |
75,553 | 755.53 | 2/28/2022 |
(13,282) | -132.82 | 3/2/2022 |
(258,085,065) | -2580850.65 | 3/4/2022 |
(8,016,463,292) | -80164632.92 | 3/7/2022 |
1,422,339,627 | 14223396.27 | 3/11/2022 |
(1,969,211) | -19692.11 | 9/12/2023 |
(27,992,641) | -279926.41 | 9/13/2023 |
(23,123,433) | -231234.33 | 9/14/2023 |
(3,220,786) | -32207.86 | 9/15/2023 |
51,598,697 | 515986.97 | 9/17/2023 |
(55,813,719) | -558137.19 | 9/18/2023 |
(7,931,531) | -79315.31 | 9/19/2023 |
(256,794,370) | -2567943.70 | 9/20/2023 |
651,586,614 | 6515866.14 | 9/21/2023 |
57,701,558 | 577015.58 | 9/22/2023 |
2,629,118 | 26291.18 | 9/23/2023 |
886,234 | 8862.34 | 9/24/2023 |
(274,063,580) | -2740635.80 | 9/25/2023 |
72,643,977 | 726439.77 | 9/26/2023 |
(816,501,250) | -8165012.50 | 9/27/2023 |
(100,373,484) | -1003734.84 | 9/28/2023 |
(39,754,540) | -397545.40 | 9/29/2023 |
80,285,531,108 | 802855311.08 | 9/30/2023 |
(59,039) | -590.39 | 12/31/2023 |
Which area would you suggest me to put the question on?
Thanks.
Hi @GAPER ,
Not sure why but your issue is with the first value of the divided by 1000, it seems like the value is to low. made some tests and removing the value or making it above -51 it works properly.
Don't know why this is ocurring but maybe you can add a post in the issues part of the forum.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |