NORM.INV function

[Villepst]

Hello,

I am new to Power BI and I have an issue.

I would like to create a measure with a function NORM.INV which should be available in POWER bi.

Unfortunately, when I type the function NORM.INV , there is no this function available in my power BI.

Could anyone help me with this issue? Or are there other ways to calculate the same result without thid function ?

My power bi is updated and it is the lastest version.

Thank you.

[Greg_Deckler]

It is there in DAX: https://docs.microsoft.com/en-us/dax/norm-inv-dax

And it comes up when I type in the DAX formula bar. Are you trying this in the Desktop or in Query Editor?

[Villepst]

I try it in desktop because I work on DirectQuery so I cannot work in query editor.

I did the same way but it is not showed up.

[Greg_Deckler]

Ah, see details matter. Direct Query, that function is not supported.

https://docs.microsoft.com/en-us/analysis-services/tabular-models/dax-formula-compatibility-in-direc...

[Villepst]

Do you have any other ways to calculate the same result ? 

It would be nice.

Thank you

[Greg_Deckler]

https://www.youtube.com/watch?v=FGePMTQAPmw

https://infocenter.informationbuilders.com/wf80/index.jsp?topic=%2Fpubdocs%2Freporting%2FUsingFuncti...

https://corporatefinanceinstitute.com/resources/excel/functions/norm-inv-function/