DAX Fridays! #142: IRR, XIRR and XNPV in DAX

In todays video I will show you how to calculate XIRR (straight forward) but also how to calculate IRR (missing function in DAX)
#curbal #daxfridays #powerbi

SUBSCRIBE to learn more about Power and Excel BI!

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:

************

************

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen, @ruthpozuelo

#daxfridays #curbal #dax #powerbi #mvp

[VagnerKogikoskiJunior]

These videos are great, all of them are really helpful. Keep going the good work!

[helenngorettyrosascolin]

You saved me, many thanks from México

[benoslgmailcom]

Hi Ruth,

I really like your videos, one question
what if i want to discount back future cash flow periods, and those periods are the linear projection for the next 10 years of data (for example 2021 to 2030).
how can I do that?

[danielhuang]

Can you run a what if scenario for the XIRR? For example. Let's say your investment cost is -1000 and CF Years 2-5 is 250 per year. If you receive a subsidy of 300 in the first year, decreasing your investment cost to -700, what is the XIRR? I know you can do it by creating a calculated column with the subsidy in year 1, but can you do it more dynamically (e.g. allowing users choose what subsidy amount?)

[ihebchafai]

it will be nice if you can share DAX Every day :)