Forum Discussion

Broeselchen's avatar
Broeselchen
Helper 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])

Broeselchen's avatar
Broeselchen
Helper III
3 years ago

Sorry, this didn't work.

Migasuke's avatar
Migasuke
Memorable Member
3 years ago

Strange that it does not work for you, but I see that amitchandak has some alternative solution.
Good luck with your project!