IRR formula in DAX working the same way as Excel one

[SwiatLudzieTy]

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

[johnt75]

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.

[SwiatLudzieTy]

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