topic Line-to-line amplitude in DAX Commands and Tips

Line-to-line amplitude

lafbraga — Fri, 15 Sep 2023 22:59:53 GMT

Friends good night.

Help me solve an issue that I'm not able to solve.

Image a table with two columns

In one analysis and in the other results. For example:

Analysis column - Result column

Turbidity - 1.0

Color - 6.0

Ph - 7.0

Conditionivity - 147

Turbidity 1.2

Color - 6.2

Color - 6.6

Ph - 7.2

There are several mixed analyses.

How would I calculate the amplitude line by line according to a filter applied in a data segmenter.

Type: If I select COLOR, Bi makes an imaginary column with the color values and calculates it like this:

Color - "Imaginary Table"

6.0 - null

6.2 - 0.2 (6.2-6.0)

6.6 - 0.4 (6.6-6.2)

And finally, return to the average of these values (0.3)

Re: Line-to-line amplitude

lbendlin — Mon, 18 Sep 2023 22:42:29 GMT

Instead of the average of the difference why not show the standard deviation?

see attached.

Re: Line-to-line amplitude

lafbraga — Tue, 19 Sep 2023 02:45:12 GMT

Yes, lbendlin.

We were trying to calculate the average of the amplitude precisely to calculate the standard deviation. Until I discovered I could calculate the standard deviation directly.

I resolved it exactly that way. Using the population standard deviation (STDEV.P).

Thanks