Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 Positive = 650 Negative = 0
Month 2 Positive = 650 Negative = -400
........
Help me please?
Hi @ruinaldo,
I think the final requirement is the same as that in your old thread. Please check whether my suggestion is helpful to your scenario.
Regards,
Yuliana Gu
How can i upload the file storage in my pc to send you?
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.
Sorry but i do not understand. Show your data and your expected result. Where is suggested formula giving you the incorrect result?
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)
.......
......
Hi,
Share the link from where i can download your file.
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |