Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Formula

Hi all,   The formula below is used in excel for column CoV. =IFERROR(STDEV.S(B6:CN6)/CP6,0)     How can I implement the same in PowerBI Matrix visual? Any help is appreciated! Thank yo...
Help appreciated
Help Requested
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Sure. Maybe like this?

    DIVIDE (
    STDEV.S ( Table1[Quantity_1] ),
    AVERAGE ( Table1[Quantity_1] )
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi AlexisOlson 

Is there a way I can implement that excel formula in the Matrix visual PowerBI?

 

Thank you for your help!

-Megha

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Sure. Maybe like this?

DIVIDE (
    STDEV.S ( Table1[Quantity_1] ),
    AVERAGE ( Table1[Quantity_1] )
)