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 ,

AFAIK, power bi data model not contains row index and column index.
I'd like to suggest you add a index column on query editor side, then you can write complex conditions to return correspond calculation formula based on current row index.

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for the info Anonymous .

Already created an index using the formula below as my table is created using dax:

Index = CALCULATE(COUNTROWS('CR Trend'), FILTER(ALL('CR Trend'), 'CR Trend'[Year-MonthName].[Date]<= EARLIER('CR Trend'[Year-MonthName].[Date])))

However tried creating some conditions but it's not working. I don't know what functions to be use etc as I am new to DAX functions.

 

Any suggestion how to build that condition is very much appreaciated.