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])

Migasuke's avatar
Migasuke
Memorable Member
3 years ago

Hi Broeselchen ,
If I understand well - you want to have new column with Total Sales, correct?
If yes - please try following formula:

 

  • 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!