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] )
)
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Anonymous  best practice, unpivot first

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi smpa01 , Thank you!

 

Its not Pivot in PowerBI.

Thats the excel screenshot which I put.

I would like to implement that formula, =IFERROR(STDEV.S(B6:CN6)/CP6,0) in PowerBI Matrix visual.

This is how Matrix Visual look like:

How can I do that?

 

Any help is appreciated!

 

Thank you!

Megha

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous  how does your data look like? Is it pivoted or unpivoted?

    • 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?