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)

        .......

        ......