Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Substracting rows with dax, using groups

Hi all,   I have seen this question a few times on the board, but I could not figure it out on my own. I have a table with 3 relevant columns within Power BI ( I recreated them in Excel to as an e...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Anonymous ,

     

    To reproduce your senario in power bi. You can create a calculate column using DAX like pattern below:

     

    Result =
VAR Current_Group = Table[Group]
VAR Previous_Group = Current_Group - 1
VAR Current_Average =
    CALCULATE (
        AVERAGE ( Table[amount] ),
        FILTER ( Table, Table[Group] = Current_Group )
    )
VAR Previous_Average =
    CALCULATE (
        AVERAGE ( Table[amount] ),
        FILTER ( Table, Table[Group] = Previous_Group )
    )
RETURN
    Current_Average - Previous_Average

    Community Support Team _ Jimmy Tao

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

v-yuta-msft's avatar
v-yuta-msft
Community Support
7 years ago

Anonymous ,

 

To reproduce your senario in power bi. You can create a calculate column using DAX like pattern below:

 

Result =
VAR Current_Group = Table[Group]
VAR Previous_Group = Current_Group - 1
VAR Current_Average =
    CALCULATE (
        AVERAGE ( Table[amount] ),
        FILTER ( Table, Table[Group] = Current_Group )
    )
VAR Previous_Average =
    CALCULATE (
        AVERAGE ( Table[amount] ),
        FILTER ( Table, Table[Group] = Previous_Group )
    )
RETURN
    Current_Average - Previous_Average

Community Support Team _ Jimmy Tao

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