Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

STDEV.S function in DAX to target specific cell range

Hi Everyone,   I badly need help to this, I've been searching for a solution in this community for days but still not successful.   I have a table in excel that I wanted to create as a calculated...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous ,

    Please try to use below calculated column formulas if they suitable for your requirement:

    Total = [Column 1]+[Column 2]

STDEV.S =
VAR curr = [Month Year]
RETURN
    STDEVX.S (
        FILTER (
            ALL ( T5 ),
            [Month Year]
                >= DATE ( YEAR ( curr ) - 1, MONTH ( curr ), DAY ( curr ) )
                && [Month Year] <= curr
        ),
        [Total]
    )

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

Please try to use below calculated column formulas if they suitable for your requirement:

Total = [Column 1]+[Column 2]

STDEV.S =
VAR curr = [Month Year]
RETURN
    STDEVX.S (
        FILTER (
            ALL ( T5 ),
            [Month Year]
                >= DATE ( YEAR ( curr ) - 1, MONTH ( curr ), DAY ( curr ) )
                && [Month Year] <= curr
        ),
        [Total]
    )

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

I was able to replicate the formula you've provided and make it works. This is what I am looking for.

 

Thanks you very much for your help on this.