Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kmoxley
Frequent Visitor

Normdist

Does anyone have the DAX equivalant to the excel func Normdist. I need to creat the following collum =Average CGI (a Z-score I alrready calulated)*100.

3 REPLIES 3
Greg_Deckler
Super User
Super User

CONFIDENCE.NORM?

https://msdn.microsoft.com/en-us/library/mt171509.aspx

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Close but no. I'm not looking for the significants interval. 

@kmoxley- Did you ever find a solution to this?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.