Forum Discussion

ri2sina's avatar
ri2sina
Icon for Helper I rankHelper I
10 years ago

Wrong data on the chart

Hello!   Please, help to understand what's the problem.   I have merged new column to a table and then I've calculated with it one new custom column in Power Query. Everything is perfect, BUT... ...
Need Help
Mi2n's avatar
Mi2n
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Can you filter the date field in the  "Adwords Revenue and Cost" table to have only the value Apr 22, 2016 in the Query editor and provide a screenshot?

 

The only way that the revenue total could get reduced is, if there are any other negative values in that table for that date.

ri2sina's avatar
ri2sina
Icon for Helper I rankHelper I
10 years ago

Here is only the 22nd of April, filtered in Power Query, please..

 

http://prntscr.com/axwyg3

 

And not only this date is wrong. I have other tables with calculated columns and there is the same thing... I can't understand why it's happen, because earlier i did the same things and everything was ok(