Missing financial DAX functions

[maasool]

Hi

I am missing all financial DAX functions in Power Pivot. How to get them?
I am using Microsoft 365.

Best regards
Sander

[v-yalanwu-msft]

Hi, @maasool ;

dax is in power bi desktop, the M language used in powerquery; The power pivot is similar to power query, using M instead of dax.

How to use the Query Editor in Power Pivot - YouTube

Difference Between Power Pivot, Power Query and Power BI (fluentpro.com)

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[LucAmanu]

The question refers to Power Pivot, not Power Query. The language used for the creation of measures is DAX, not M. 

I confirm I have the same issue: when trying to create a measure, I cannot enter any Financial Function. They are not included as a category in the "Insert Function" interface and, if entered manually, I obtain an error

'Failed to resolve name 'RRI'. It is not a valid table, variable, or function name.'.