Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
How would I calculate the Underlying profit, Debtors and Creditors with the KPIs or data available?
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.
Hi @Yrstruly2021 ,
Could you please provide the desired result with Text format or screenshot to make a deep troubleshooting?
It would be helpful to find out the solution.
Looking forward to your reply.
Best Regards
These are the Kpis or rows i have available to report on: "
Cash flow imbalance |
Cash flow from ops - management |
Cash flow from trading |
Profit before Brambles allocations Total |
Depreciation and amortisation |
IPEP expense |
Disposals & impairment of fixed assets |
Profit on disposal of pooling equipment |
Scrapped pooling equipment |
Impairment or valuation adjustment of pooling equipment |
Disposals or valuation adjustments of other fixed assets |
Other cash flow from trading adjustments |
Share-based payments expense |
JV adjustment |
JV share of PAT |
JV dividends received |
Pension plan adjustment |
Trading cash flow adjustments |
Working capital mvts incl. provisions |
Working capital mvts excl. provisions |
Debtor movements |
Creditor movements |
Inventory movements |
Prepayment movements |
Other asset movements |
Provision movements |
Dilapidation provision paid |
Working capital - budget flex |
Investing cash flows (excl. M&A activity) |
Capital expenditure |
Purchases of PP&E |
Pooling equipment acquired |
Pooling equipment additions |
Pooling equipment replacements |
Pooling equipment internal transfers |
Other PP&E acquired |
Other PP&E additions |
Other PP&E replacements |
Other PP&E internal transfers |
Change in capex creditors |
Lease adj - No longer used |
Pooling equipment internal tfr POSA adj |
Purchases of intangible assets |
Software intangibles acquired |
Other intangibles acquired |
Deferred expenditure |
Investments made |
Investments acquired |
Joint venture loans |
Capital expenditure cash flow adjustments |
Capital expenditure - budget flex |
Proceeds from disposals |
Proceeds from disposals of PP&E |
Proceeds pooling disposals |
WDV pooling equip. disposals & write-offs |
Gain pooling equip. disposals & write-offs |
Proceeds other PP&E disposals |
WDV other PP&E disposals |
Profit other PP&E disposals |
Change in loss compensation balances |
Change in deferred fixed asset proceeds |
Proceeds disposals of intangible assets |
Proceeds software intangibles disposals |
WDV software intangibles disposals |
Profit software intangibles disposals |
Proceeds other intangibles disposals |
WDV other intangibles disposals |
Profit other intangibles disposals |
Proceeds deferred expenditure disposals |
WDV deferred expenditure disposals |
Profit deferred expenditure disposals |
Proceeds investment disposals |
WDV investments disposals |
Profit investments disposals |
Disposal proceeds cash flow adjustments |
Brambles allocations not in mgt cash flow |
Cash flow from ops - statutory adjustment |
Cash flow from ops - statutory |
Net interest paid |
Interest received |
Interest revenue |
Change in interest receivable |
Interest received cash flow adjustments |
Interest paid |
Interest expense Total |
Interest expense not impacting cash flow |
Amortisation of upfront fees |
Lease interest |
Discount unwind on long term provisions |
FX on foreign currency denominated debt |
FX on interco debt |
Finance expense capitalised |
Derivatives - FX forward revaluation |
Hedges of foreign currency interco debt |
Interest rate swaps FV adj. cash flow hedges |
Interest rate swaps FV hedges |
Interco interest and guarantee fees |
Bond fair value adjustment |
Interest cash flow not impacting expense |
Change in interest payable |
Interest paid on other debt instruments |
Interest paid on leases |
Interest portion of financial instruments settled |
Interest paid cash flow adjustments |
Net tax paid |
Tax paid |
Tax refunded |
Fiscal unity tax transfers |
Tax cash flow adjustments |
Free cash flow before dividends |
Dividends paid |
Dividends paid to Brambles shareholders |
Dividends paid to minorities |
Dividend cash flow adjustments |
Free cash flow after dividends |
Entity acquisitions and disposals |
Entity acquisitions |
Total purchase price of entities acquired |
Purchase price of entities acquired |
Cash price of entities acquired |
Non-cash consideration in purchase price |
Costs directly incurred on entity acquisitions |
Deferred settlement of entity acquisitions |
Deferred settlements now paid |
Non-cash consideration for entity acquisitions |
Net cash held by entity at date of acquisition |
Entity acquisition cash flow adjustments |
Proceeds from entity disposals |
Net price of entities disposed |
Agreed sale price of entities disposed |
Cash price of entities disposed |
Non-cash consideration in agreed sale price |
Costs directly incurred on entity disposals |
Provisions raised on entity disposals |
Net change disposal provisions and accruals |
Deferred settlement of entity disposals |
Deferred settlements now received |
Non-cash consideration for entity disposals |
Net cash held by entity at date of disposal |
Entity disposal cash flow tax adjustments |
Entity disposal cash flow other adjustments |
Other cash flow items |
Net equity raised by Brambles Limited |
Cash share issues by Brambles Limited |
Cost sharing payments to Brambles Limited |
Cash paid for share buyback |
Equity raised cash flow adjustment |
FX adjustments to cash flow |
Interco cash flows |
Interco interest and guarantee fees |
Interco royalties |
Statutory reallocations |
Internal restructuring |
Interco dividends Total |
Change in interco balances |
Change in interco recharge clearing |
FX on interco debt |
Interco capital issued |
Interco capital returned |
Cash balances transfer on merging entities |
Interco cash flow adjustments |
Cashflow budget flex adjustment |
Financial instruments principal settled |
Net debt increase/(decrease) |
Loans drawn down |
Loan principal repaid |
Leases principal repaid |
Change in cash net of overdraft |
"
I have grouped them accordingly see "
Debtors:
Debtor movements
Other current debtors
Creditors:
Creditor movements
Change in capex creditors
Change in interco balances
Change in interco recharge clearing
Interco capital returned
Under Lying Profit:
Profit before Brambles allocations Total
Profit on disposal of pooling equipment
Profit other PP&E disposals
Profit investments disposals
Profit software intangibles disposals
Profit other intangibles disposals
Profit deferred expenditure disposals
JV share of PAT
Cash Flow Imbalance:
Cash flow from ops - management
Cash flow from ops - statutory
Cash flow from trading
Free cash flow before dividends
Free cash flow after dividends
Net debt increase/(decrease)
Cashflow imbalance
Change in cash net of overdraft
".
Please advice if my groupings are correct?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
9 | |
8 | |
6 | |
5 |
User | Count |
---|---|
17 | |
14 | |
10 | |
9 | |
6 |