Forum Discussion
Missing financial DAX functions
Hi
I am missing all financial DAX functions in Power Pivot. How to get them?
I am using Microsoft 365.
Best regards
Sander
2 Replies
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.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.'.
