Expense Tracking

David --

If you are using Microsoft Project with Project Online or Project Server, your app admin could create a custom enterprise Project field with a lookup table that contains the values CAPEX and OPEX.  Then a value from that field could be specified for each project.  That would allow the expenditures to be separated accordingly in a Power BI report.  If you are using Microsoft Project desktop only, first of all, how are you creating reports in Power BI, since the Power BI app does not connect to the Microsoft Project desktop app?  Anyway, if you are using the Microsoft Project desktop application only, you could create a custom task Text field with a lookup table containing the CAPEX and OPEX values, and then specify a value from this field for every task.  Just a thought.  Hope this helps.