Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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?
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.
Ah, see details matter. Direct Query, that function is not supported.
Do you have any other ways to calculate the same result ?
It would be nice.
Thank you
https://www.youtube.com/watch?v=FGePMTQAPmw
https://corporatefinanceinstitute.com/resources/excel/functions/norm-inv-function/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |