Forum Discussion

BMac-Coop's avatar
BMac-Coop
Frequent Visitor
4 years ago

Azure Cost Management Data - Getting & Grouping Charges by Latest Tag Value

I've been working on this on-and-off for weeks and I fear there's an easy answer I'm not seeing.  The source data is the Azure Costing feed.  (pbix here for a sample.  First time giving a PBIX, hopef...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  BMac-Coop ,

Here are the steps you can follow：

1. Create measure.

Measure =
CALCULATE(SUM('Sheet1'[PITProjectAccountingCode]),FILTER(ALL(Sheet1),'Sheet1'[ResourceName]=MAX('Sheet1'[ResourceName])&&
'Sheet1'[BillingPeriodEndDate]=
MAXX( FILTER(ALL(Sheet1),'Sheet1'[ResourceName]=MAX('Sheet1'[ResourceName])),[BillingPeriodEndDate])))

2. Result:

If you need pbix, please click here.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

BMac-Coop's avatar
BMac-Coop
Frequent Visitor
4 years ago

Hi.  Thanks for this.  It works in your PBIX file, but I'm having problems implementing it with my real data.  Funny enough, it's doing what I would expect it to do (which shows I'm still struggling to read what it's supposed to be doing).  It's basically adding up all of the PITProjectAccountingCode values and putting the numbers to the Measure:

 

Any ideas why this would be happening?  I've checked data types against your pbix file and everything looks identical.