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

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?