Forum Discussion

Broeselchen's avatar
Broeselchen
Icon for Helper III rankHelper III
3 years ago
Solved

Calculated column with a sum

Hello, I need a calculated column with the total sales of each customer. I can't do it in a measure because I need it to eliminate the duplicates for the connection to an other table. Example: ...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Broeselchen , A new column

     

    Sumx(filter(Table, [Customer] = earlier([Customer]) ), [Sales])

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

Broeselchen , A new column

 

Sumx(filter(Table, [Customer] = earlier([Customer]) ), [Sales])