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

[Walt]

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,

[v-jianboli-msft]

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.

[Walt]

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

[v-jianboli-msft · Accepted solution]

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.

[Walt]

@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.  

[tamerj1]

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?

[Walt]

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