[Power BI] Generate ContractedUnitPrice and ContractedCost when missing

[flanakin]

⚠️ Problem

Cost Management does not include ContractedUnitPrice and ContractedCost for all records.

For EA accounts, this is seemingly random where some records include ContractedUnitPrice and others don't, but they all seem to have ContractedCost.

For MCA, neither column is available for reservations.

🛠️ Solution

For EA, calculate the ContractedUnitPrice from the ContractedCost column by dividing it by the PricingQuantity.

For MCA, since neither price nor cost is available, join the cost data with the pricesheet and calculate the cost by multiplying the price by PricingQuantity.

ℹ️ Additional context

Both of these workarounds will slow down report generation. If you are faced with this issue, please file a support request to help raise the priority for the Cost Management team to resolve the underlying data issue.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.
3. File a support request with the Cost Management team to ensure these values are always populated correctly.