Calculate stdv.p measure for a specific range of time

[JeremieA]

Hello, 

I currently use 

STDVP = STDEV.P(Table[average])

but Im trying to make a measure that calculate the stdv.p in the table but only for a certain period of time.

So I have a Table that look like this

date	average
2023-03-01	4
2023-03-02	5
2023-03-03	8
2023-03-04	4
2023-03-05	6
2023-03-06	9
2023-03-07	3
2023-03-08	1
2023-03-09	12
2023-03-10	6

I absolutly need the whole table but if I want to calculate only for dates 2023-03-01 to 2023-03-06, how would I do that?

Thank you

[Ritaf1983 · Accepted solution]

Hi @JeremieA 
You can slice your measure in several ways.

For example :
You can create a calendar table

Create a relationship with your data table:

And put the date from the calendar on your slicer

From this moment your measure is dynamic

You can download sa,ple file from here:Link 

More information about calendar tables is here:

https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions

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

[JeremieA]

Thank you for the response, but I have to make this measure in around 50 differents, non related table in my dashboard, using a slicer would be less than optimal

[Ritaf1983]

Hi @JeremieA 

To be able to help, I recommend fully and clearly describing what is required and what the desired result is.

[JeremieA · Accepted solution]

I found a way 

STDVMeasure = CALCULATE(

    STDEV.P(Table[average),

    DATESBETWEEN(

        Table[date],  

        date(2022,04,01),  

        date(2023,03,31)  

    )

)

Thanks for your time

[Ritaf1983 · Accepted solution]

Hi @JeremieA 
You can slice your measure in several ways.

For example :
You can create a calendar table

Create a relationship with your data table:

And put the date from the calendar on your slicer

From this moment your measure is dynamic

You can download sa,ple file from here:Link 

More information about calendar tables is here:

https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions

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