Calculate varicane Azure cost consumprion on Power BI desktop

[Anonymous]

Hi all,

i have a consumption downloaded by Azure Cost management connect on power BI desktop.

I need calculate a variance for resource group and for resource by a month.

Can you help me?

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

Yes, of course, there are three images in the same table,

You would need to calculate variation by resource, resource group, and type. Divided by month and quarter

[v-lionel-msft]

Hi @Anonymous ,

Please refer to the link.

DAX Variance Calculations 

Best regards,
Lionel Chen

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

[Anonymous]

This solution don't work.

Have you another suggestion for me?

[v-lionel-msft]

Hi @Anonymous ,

Has your problem been solved?

If not, please provide reproducible sample data in table form and expected output results.

Best regards,
Lionel Chen

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