How do you work out savings made through reservations and savings plans?

Knell, Stephen 0 Reputation points

I have pulled amortized data into PowerBI, filtered down charge type to usage, filtered to only show those lines with a reservation name and all the unit prices are zero. All articles I have read say the only thing way to work out savings is to subtract unit price from effective price and multiply by the quantity, but with a zero unit price I can't do that, any suggestions?

Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
1,991 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. SadiqhAhmed-MSFT 36,881 Reputation points Microsoft Employee

    Hello @Knell, Stephen Thank you for reaching out to us on Microsoft Q&A platform. Happy to help!

    From the title of the question, I understand that you want to work out savings made through reservations and savings plans and wanted an alternative solution/suggestion to accomplish it.Once the usages details amortized raw data is pulled in Cost Management Connector in PowerBI Desktop, you can create 3 custom columns as below with the respective formulas:

    OnDemand cost – If no RI 🡪 The formulae you will use here is [UnitPrice]*[Quantity]

    Cost with RI 🡪 The formulae you will use here is [EffectivePrice]*[Quantity]

    Savings 🡪 The formulae you will use here is [OnDemand Cost]-[Cost With RI]

    Generally the amortized usage will show the unitprice for the chargetype usage and pricing model as Reservation. If you are seeing 0, you might have ActualUsage instead of amortized usage.

    Hope this helps. If you need further assistance, you can reach out to Azure cost management support team by raising a support request. The ticket enables you to work closely with the support engineers and get a quick resolution to your issue.

    Here is the link - to create support case.

    Note: Cost Management support is included in the Basic Support Plan without any charge.

    If the response helped, do "Accept Answer" and up-vote it