Forum Discussion
Solved
Map a LocalAccount to GlobalAccountPositive or GlobalAccountNegative based on the sum of the Amount
Hi, I'm trying to do a Balance Sheet report and I need to map Local Accounts to GlobalAccounts. If the sum(Amount) for the LocalAccount of all data until the selected period is >=0 then map it to G...
Hi katemarkoska ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Measure = var _sum= SUMX(ALLSELECTED('Table'),[Amount]) return IF( _sum>= 0 ,MAX('Table'[GlobalAccountPositive]),MAX('Table'[GlobalAccountNegative]))2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi katemarkoska ,
I created some data:
Here are the steps you can follow：
1. Create measure.
Measure =
var _sum=
SUMX(ALLSELECTED('Table'),[Amount])
return
IF(
_sum>= 0 ,MAX('Table'[GlobalAccountPositive]),MAX('Table'[GlobalAccountNegative]))
2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly