Matrix move values between columns initial balance to final balance

[mvalerio]

Hi,

I try to do this on power bi buy the result is not what i specting:

I need to sum the final balance to the initial in a matrix visualization:

And final balance go to inicital next month

Matrix

samples files here!!!

https://we.tl/t-Zu1trVcy6a

Thanks so much!

Regards

Matias

[V-pazhen-msft]

@mvalerio 

Power bi and excel have different calculating systems, where excel formulas you used is based on cells where power bi dax are calculated on row and columns.

I have check the sample files and see if I can get this around, but unfortunately as far as I know, this is not possible.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.