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 you!

Megha

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

8 Replies

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