Forum Discussion

Gavroche97's avatar
Gavroche97
Frequent Visitor
3 years ago
Solved

Create a column that gives conditionnal sum

Hi,   I would like to create a column that would give the sum of a column for each occurences of another column. Exemple: Cat   Value   SumColumn A       3              4       A       1       ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    It is for creating a new column by writing DAX.

     

     

    Sum Column =
SUMX (
    FILTER ( Data, Data[Category] = EARLIER ( Data[Category] ) ),
    Data[Value]
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column by writing DAX.

 

 

Sum Column =
SUMX (
    FILTER ( Data, Data[Category] = EARLIER ( Data[Category] ) ),
    Data[Value]
)