Instead of trying to replicate your financial statements with formulas you can extract your statements in a single table. Try this approach, it would save you a lot of time having to combine data from 100+ different tables in the native QBO connector: https://vidi-corp.com/connect-quickbooks-online-to-power-bi/