topic Re: VAR.P STDEV.P all prevous dates in a column in DAX Commands and Tips

VAR.P STDEV.P all prevous dates in a column

Walt — Thu, 01 Sep 2022 16:33:31 GMT

I am having issues getting all the VAR.P and STDEV.P Values for previous dates. The Measure I am using works with a date slicer to find the previous values, but when I try to get a Column I have issues.
The end goal is to find the MAX, MIN and AVG of VAR.P and STDEV.P...
I am using these measures:
_m_VAR.P = VAR.P(Table[Values])
_m_STDEV.P = STDEV.P(Table[Values])

I can see the data I need in the slicer. Below are the examples:
Any help would be appreciated.

Thank you,

Re: VAR.P STDEV.P all prevous dates in a column

tamerj1 — Thu, 01 Sep 2022 17:59:39 GMT

Hi Walt

when you add the date to the filter contaxt apparently you're drilling through to the row level. The Stdv and the Var of a single value is 0. What values are you expecting to see here?

Re: VAR.P STDEV.P all prevous dates in a column

Walt — Thu, 01 Sep 2022 18:53:40 GMT

I am trying to get the VAR and STDV for each date. The end goal is to use those values for each date and find the Min, Max and AVG.
something like this...
Date : VAR
June 30th : 17.93
March 1st : 18.73

Re: VAR.P STDEV.P all prevous dates in a column

v-jianboli-msft — Tue, 06 Sep 2022 09:11:40 GMT

Hi Walt ,

Based on your description, I have created a simple sample:

Please try:

_STDEV.P = CALCULATE(STDEV.P('Table'[Value]),FILTER(ALL('Table'),[Date]<=MAX('Table'[Date]))) _VAR.P = CALCULATE(VAR.P('Table'[Value]),FILTER(ALL('Table'),[Date]<=MAX('Table'[Date])))

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: VAR.P STDEV.P all prevous dates in a column

Walt — Tue, 06 Sep 2022 17:34:08 GMT

v-jianboli-msft,
Thank you, this helped me to see the values for each date, however I am still having issues finding the AVG, MIN, and MAX of the values when filtered by catigories.

Re: VAR.P STDEV.P all prevous dates in a column

v-jianboli-msft — Wed, 07 Sep 2022 01:42:55 GMT

Hi Walt ,

You mentioned The end goal is to find the MAX, MIN and AVG of VAR.P and STDEV.P before. What is the exact meaning of MAX, MIN and AVG? For value or for VAR.P and STDEV.P?

Please provide more details about your problems or give a simple example aboult the expected result.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: VAR.P STDEV.P all prevous dates in a column

Walt — Wed, 07 Sep 2022 01:50:09 GMT

It's sorted. It was a request that was not needed. Thank you.