Pivot Table in Excel to PowerBI

SAP Data will be the transactional data that is joined with dimensional data/tables. The SAP source data is then pivoted, as seen in 1st image above.

My challenge is, building the pivoted table in PowerBI from the SQL data source(extract from SQL), see:https://docs.google.com/spreadsheets/d/12RjkTzq1elO3bRzvu4LZ8DxHypZlzIsE/edit?usp=sharing&ouid=104129043494164133703&rtpof=true&sd=true 

The Matrix/Pivot feature in Powerbi will work. Now it is building the formulas like, e.g "=-SUMIF('SAP Source'!C[-10];'Cash Flow'!RC[-4];'SAP Source'!C[-3])+334776"

into PowerBI. So all of the referencing is shifting from Excel sheets to SQL table(s).

The data link(https://docs.google.com/spreadsheets/d/1-FfCgSXpK5fNyH3AWyvwfUwBXT9WQqBb/edit?usp=sharing&ouid=104129043494164133703&rtpof=true&sd=true ) contains(SAP + Dimension tables) the tab Cash Flow where you can investigate how the values in Column G are compiled. The primary key contains duplicates, these can be filtered.

Data referential integrity is Many - 1. There can be multiple Account_Number linked to 1

ZTBR_TransactionCode.

Please advise on optimisation methods.