Forum Discussion
Moving average mismatch
Hi All, We use Oracle Ole db connector. We already have an exisiting Power bi report. We made some changes to the sql to calculate moving average on certain columns. When tried to pull this query...
The problem with averages is that they are not additive. If you slice or apply filters use can't use a precalculated average to generate a new average. You should really use a measure so that this will be dynamically calculated in respect to filter etc that are applied to the report
Agreed, averaging the average might create problems. But the load itself is showing wrong values in Power query editor, hence I was wondering what the issue could be. I shall surely consider the dax option ans see its feasibilty.
Thanks,