Forum Discussion
Solved
Query Exceeds
I have created a calculated column like this A= IF ( ISBLANK('Fact'[Inv No]), 'Fact'[Amt], IF ( 'Fact'[account_id] = "AP", 'Fact'[local_amt], 'Fact'[local_amt] * -1 ) ) After this i have c...
Hi SudhanshuD4512,
Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to Hans-Georg_Puls , kushanNa , syahmisi98 and amitchandak for prompt and helpful responses.
I’ve tried to reproduce the scenario using the M code below. Please review and adjust it according to your data source. If the issue still persists, feel free to share more details, and we’ll be happy to assist further.
Thanks & Regards,
Prasanna Kumar
Net Activity =
IF (
ISBLANK('Fact'[Inv No]),
'Fact'[Amt],
IF (
'Fact'[account_id] = "AP",
'Fact'[local_amt],
'Fact'[local_amt] * -1
)
)
Debit is calculated as if we sum net activity, if(net activity>0,net activity,0)
Credit if(net activity<0,net activity,0)*-1
| Inv Num | AccountID | Local Amount | Amt |
| 1000 | AP | 300 | 100 |
| 1000 | AP | -350 | 200 |
| 1000 | AP | 400 | 200 |
input
Output below i want
| Inv Num | AccountID | Net Activity | Debits | Credits |
| 1000 | AP | 350 | 350 | 0 |