Arithmetic in Q&A questions

[pbiideas1]

I want to be able to write a question that says "Revenue - Tax over time" and have Q&A create the calculation for me on the fly.

[Drewbr]

I to would like to perform a question that would allow me to do math functions for example. 'total r for q1 / total g for q1' = % Thanks

[Drewbr]

I to would like to perform a question that would allow me to do math functions for example. 'total r for q1 / total g for q1' = % Thanks

[Drewbr]

I to would like to perform a question that would allow me to do math functions for example. 'total r for q1 / total g for q1' = % Thanks

[Drewbr]

I to would like to perform a question that would allow me to do math functions for example. 'total r for q1 / total g for q1' = % Thanks

[Drewbr]

I to would like to perform a question that would allow me to do math functions for example. 'total r for q1 / total g for q1' = % Thanks

[beneuto1]

Another example (for Azure usage data). What is the average daily cost? i.e. Sum(cost) / Sum(count of date). Could also be expressed as: What is the total cost divided by the total count of date? It is not currently possible to get the result desired above. The first query returns a line graph with a point for every day and the average record value within each day. The second query returns the totals for cost and day count but does not do the divide.

[nishalit]

We are happy to announce that Q&A now supports the following arithmetic operations:, to learn more: https://powerbi.microsoft.com/en-us/blog/power-bi-september-2020-feature-summary/#QA_arithmetic