PowerBI/SQL/PowerApps formulas

[walex]

I have two tables in sql.  

Table 1 (Date, Total in)

Table 2 (Date, Total out)

I am using Powerapps to create user input screens to input data into the sql tables.

I am using PowerBi to display the table information in a custom report.

I would like to create a calculated column in my sql Table 2 that keeps a running balance.  Yesterdays reading + Total IN - Total Out.

[lbendlin]

Sounds good. What have you tried and where are you stuck?

Note:  This requires a PowerApps Premium license for each of your report users (even when they don't need a Power BI Pro license)