How to do dataset Aggregation with Invoke-AzCostManagementQuery?

[Sweggle]

The documentation on this powershell cmdlet is very unclear. It just says 'Hashtable' for the required input. A hashtable is not allowed it seems when trying to run eg by creating one and feeding it in as a variable.

When i query the Cost Management API using Postman, i can do something like this:

"dataset": {
"aggregation": {
"totalCost": {
"name": "Cost",
"function": "Sum"
},
"totalCostUSD": {
"name": "CostUSD",
"function":" Sum"
}
},

How do I recreate this with Invoke-AzCostManagementQuery?

Thanks!

[CaptainFanZzz]

@Sweggle , when I try to use hashtable for -DatasetAggregation , even if it’s null value, it works.

Here's my script:

$hashtable = @{}
Invoke-AzCostManagementQuery -Scope subscriptions/xxxx-xxxx-xxxx-xxxx-xxxx -Timeframe MonthToDate -Type Usage -DatasetAggregation $hashtable

or

$aggregation = Get-Content ./Aggregation.json | Convertfrom-Json -AsHashtable
Invoke-AzCostManagementQuery -Scope subscriptions/xxxx-xxxx-xxxx-xxxx-xxxx -Timeframe MonthToDate -Type Usage -DatasetAggregation $aggregation

[Sweggle]

@CaptainFanZzz thanks for your answer, would you be willing to show the format of your aggregation.json?

[CaptainFanZzz]

Sure, my json file is as below.

 {
      "totalCost": {
        "name": "PreTaxCost",
        "function": "Sum"
      }
    }
  

[Sweggle]

Awesome thank you very much thats working just great. Appreciated. @CaptainFanZzz

[dingmeng-xue]

@Sweggle , Did above reply answer your question?

[Sweggle]

Yes thanks to the community on here.