In my recent quest to create or catalog as many DAX equivalents for Excel functions, I coded this one with one arm tied behind my back:
MULTINOMIAL =
VAR __Table =
ADDCOLUMNS(
'Table',
"Factorial",FACT([Column1])
)
RETURN
DIVIDE(
FACT(SUMX('Table',[Column1])),
PRODUCTX(__Table,[Factorial]),
0
)
Follow on LinkedIn
@ 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!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
