search

flanakin / cost-management-powerbi

A set of Power BI reports for Microsoft Cost Management
MIT License
10 stars 3 forks source link

commitment discounts savings view showing wrong data due to unit price = 0 #7

Open brunomiguelhenriques opened 1 year ago

brunomiguelhenriques commented 1 year ago

i have an mca-e agreement and the formula to calculate on demand costs for RI savings is showing me this:

OnDemandCost = if ('CostDetails'[ChargeType]="Usage",'CostDetails'[Quantity]*'CostDetails'[UnitPrice], 0)

However the unit price column comes with 0 for billing events associated to reservations usage:

image

therefore on demand cost will never be higher then amortized costs.

flanakin commented 1 year ago

Unfortunately, Cost Management does not provide UnitPrice for MCA accounts. Due to this, we cannot calculate on-demand cost for MCA accounts. I can change it to set OnDemandCost to 0 and then update it when Cost Management fixes the bug or leave it as-is so it'll just start working as soon as Cost Management fixes the bug (without you having to update anything). What would you prefer?

brunomiguelhenriques commented 1 year ago

Thanks for the quick feedback Michael!

Currently leaving the OnDemandCost to 0 will not fix my issue because it won´t give the real billing accurate costs unfortunately.

So I assume the best option so far would be to the Cost Management team to fix this issue .

Best regards,

Bruno Henriques

flanakin commented 1 year ago

I'm going to keep this open in hopes that I can spend a little time to try to merge the pricesheet data or find another workaround...