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] )
)
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Since we can't see what is in your ranges B6:CN6 and CP6, it would be useful to share what the formula is computing. The standard deviation of what divided by what?

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