topic Re: NORM.INV function in DAX Commands and Tips

NORM.INV function

Anonymous — Thu, 16 Apr 2020 13:55:27 GMT

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 — Thu, 16 Apr 2020 13:59:25 GMT

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

Anonymous — Thu, 16 Apr 2020 14:01:50 GMT

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 — Thu, 16 Apr 2020 14:06:22 GMT

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

Anonymous — Thu, 16 Apr 2020 14:07:47 GMT

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

It would be nice.

Thank you

Greg_Deckler — Thu, 16 Apr 2020 15:52:49 GMT