DAX Formula

[Anonymous]

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

[smpa01]

@Anonymous  best practice, unpivot first

[Anonymous]

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]

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

[Anonymous]

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]

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]

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]

Hi @AlexisOlson 

Is there a way I can implement that excel formula in the Matrix visual PowerBI?

Thank you for your help!

-Megha

[AlexisOlson · Accepted solution]

Sure. Maybe like this?

DIVIDE (
    STDEV.S ( Table1[Quantity_1] ),
    AVERAGE ( Table1[Quantity_1] )
)