[Power BI] Add cost summary KPIs

[flanakin]

📝 Scenario

As a FinOps practitioner, I need to monitor the average price of each resource type in order to quantify the ROI for workloads running on those resources

💎 Solution

Add the following KPIs to Power BI reports:

• Average cost per hour of compute
  • Formula: #Total spend of Virtual Machines resources / #total time used
  • Objective: To measure the average cost of running instances during the period.
  • Value: This metric provides insights into the value of resources being used. It helps organizations assess the purchase process and to enhance its effectiveness into the selection and assignation of available services in the public cloud.

🙋‍♀️ 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.