topic Re: DAX Formula in DAX Commands and Tips

DAX Formula

Anonymous — Fri, 14 Jan 2022 13:37:32 GMT

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

Re: DAX Formula

smpa01 — Fri, 14 Jan 2022 14:17:03 GMT

Anonymous best practice, unpivot first

Re: DAX Formula

Anonymous — Fri, 14 Jan 2022 14:31:32 GMT

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

Re: DAX Formula

smpa01 — Fri, 14 Jan 2022 14:41:40 GMT

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

Re: DAX Formula

Anonymous — Fri, 14 Jan 2022 14:49:28 GMT

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

Re: DAX Formula

AlexisOlson — Fri, 14 Jan 2022 15:39:05 GMT

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?

Re: DAX Formula

Anonymous — Fri, 14 Jan 2022 16:05:57 GMT

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

Re: DAX Formula

Anonymous — Mon, 17 Jan 2022 15:49:50 GMT

Hi AlexisOlson

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

Thank you for your help!

-Megha

Re: DAX Formula

AlexisOlson — Mon, 17 Jan 2022 18:44:56 GMT

Sure. Maybe like this?

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