Microsoft Idea

Completed

# Arithmetic in Q&A questions

Vote (67)

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.

Administrator on 21 Jul 2021 16:53:18

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

## RE: Arithmetic in Q&A questions

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.

## RE: Arithmetic in Q&A questions

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

## RE: Arithmetic in Q&A questions

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

## RE: Arithmetic in Q&A questions

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

## RE: Arithmetic in Q&A questions

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

## RE: Arithmetic in Q&A questions

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