Power BI

Completed

Arithmetic in Q&A questions

Vote (67)

on 03 Oct 2014 07:16:10

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

Comments (6)

Comments (6)

Ian Bennett on 16 Aug 2020 03:56:25

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.