Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Calculating Balances based on values from another Table

Hi there   I have 2 data tables (OpenStudentBal & Leavers) setup below in PowerBI.   OpenStudentBal table has 2 data columns: Mth/Yr & Opening Balance Leavers table has 3 data columns: Mth/Yr, B...
Need Help
sraj's avatar
sraj
Responsive Resident
6 years ago

Hi Everyone,

 

Need help with something similar...would like to CALCULATE the Remaining amount.

 

 

Type     JOHN            DOE           REMAINING

A          500000           50000         450000  

B          100000           40000           60000

C             5000             2000              3000

 

Please help.

 

Thanks,

Seema.