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

Its unpivoted. This is how it looks like.

But in Report field, I am using a Matrix visual, so that my data can look like this.

 

In Matrix visual, I would like to add a calculated column. I know the formula for excel version which is "=IFERROR(STDEV.S(B6:CN6)/CP6,0)" but not PowerBI. So I would like to know to create a column in the above visual and implement that formula.

 

Thank you!
Megha

 

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