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

Oh yes. Sorry! AlexisOlson 

I have attached an other screenshot.

 

I couldnt really capture the whole, but the range starts from B6.

I would like to implement the column "CoV" in PowerBI 'Matrix visual'.

 

Thank you!

Megha

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] )
)