Missing DAX functions

[stigcorneer]

Are there a difference in the collection of DAX functions between PowerBI and Powewr Pivot in Excel?
I am missing most of the financial functions in Power Pivot.

 

[sandy666]

depends on Excel version you have (the same happens with Power Query and worksheet functions - this is the method how MS makes money, among others)

 

[stigcorneer]

I have Excel 365

 

[sandy666]

depends on the subscription channel, but the PBI is updated on a regular basis, which does not mean 365 either
so live with it or use PBI
or
maybe find a combination of functions of Power Pivot to achieve what you want with single function in PBI

btw. what function is missing?

 

[stigcorneer]

The one I am looking for is NOMINAL()

 

[sandy666]

afaik NOMINAL() is in PBI only for now

New DAX functions (June 2020)

you know MS "timing"

 

[stigcorneer]

:/
Oh well, thats life.
Thanks