NORM.INV function

Question

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 · Answer

It is there in DAX:&nbsp;https://docs.microsoft.com/en-us/dax/norm-inv-dax
&nbsp;
And it comes up when I type in the DAX formula bar. Are you trying this in the Desktop or in Query Editor?
&nbsp;

anonymous · Answer

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 · Answer

Ah, see details matter. Direct Query, that function is not supported.
&nbsp;
https://docs.microsoft.com/en-us/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016?view=asallproducts-allversions
&nbsp;

anonymous · Answer

Do you have any other ways to calculate the same result ?&nbsp;It would be nice.Thank you

greg_deckler · Answer

https://www.youtube.com/watch?v=FGePMTQAPmw
&nbsp;
https://infocenter.informationbuilders.com/wf80/index.jsp?topic=%2Fpubdocs%2Freporting%2FUsingFunctions%2Fsource%2Fnumeric13.htm
&nbsp;
https://corporatefinanceinstitute.com/resources/excel/functions/norm-inv-function/
&nbsp;
&nbsp;

Forum Discussion

NORM.INV function

5 Replies

Related content

norm.inv

DATESYTD function

norm.inv

function behavior

DAX Studio space after function name