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.
Hello Friends!
I have a business need to calculate IRR in Power BI, the same way as Excel IRR formula does. It means it should assume equal-size payment periods. I know we have XIRR, but it does in fact consider the exact number days.
How do I achive classic IRR Excel formula in Power BI?
Thanks! Kamil
You could generate dummy dates which are the correct number of days apart and use that as the dates argument to XIRR, something like
SELECTCOLUMNS(
ADDCOLUMNS(
GENERATESERIES( 0, 100, 30),
"Date", [Value] + TODAY()
),
"Date", [Date]
)
which returns a date every 30 days for 100 days.
Thanks @johnt75, it defenietly seems as a correct solution. Unofrtunetly I can't validate if it's the expected result now, but I will mark your reply as Solution as sonn as I can!
Kamil
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |