Forum Discussion

ruinaldo's avatar
ruinaldo
Helper II
8 years ago

Problem with Duplicates

I have a list of clients, that duplicates in same month. My target is for each month separate the accumulated values by client and positive vs negative, in matrix table For example: Month 1 Positiv...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

There is no need to create a calculated column formula of "Accumulaed values".  In the visual, drag Month and write the following measures:

 

Positives=SUM(Data[Positive])

Negatives=SUM(Data[Negative])

Accumulated values=[Positives]+[Negatives]

 

Hope this helps.

ruinaldo's avatar
ruinaldo
Helper II
8 years ago
Thanks for your help. But i need in diferent columns the result in month 2 positive =650 and negative = -400
  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Sorry but i do not understand.  Show your data and your expected result.  Where is suggested formula giving you the incorrect result?

    • ruinaldo's avatar
      ruinaldo
      Helper II
      8 years ago

      Hi,

      I have a table of clients movements by month. I don´t need the sum of positive or negative values

      I need by month the accumulated values by client. And each month i have client balance positive others negative that i want separate in diferent columns.

      Month 1 = positive (650) = acumulated balance of clients 211000500 (500) and 211000700 (150)

      Month 2  = positive (350) = acumulated balance of clients 211000500 (200) and 211000700 (150). 

                          negative = acumulated balance of client 211000600 (-100)

      .......

      ......

       

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        Share the link from where i can download your file.