How would I calculate the Underlying profit, Debtors and Creditors with the KPIs or data available?
PBIX: PBIX: https://drive.google.com/file/d/1k1FqqgW6GCwGE6GOVXWeY6L6lAX26Gdf/view?usp=sharing
Bracs & ZTBR’s data are combined as they are different data sources. Table Cash Flow Descriptions contains all of the descriptions that are in both tables, Totals descriptions might not be in either of the two tables mentioned, but only in Table Cash Flow Descriptions.
These two tables are not related or connected directly, and thus I can not combine DAX calculations from both in a combined filter.
Calculation New Combined amount6 takes the two tables and combines them to give totals.