Power Query different table to Power Desktop (overwriting values)

[Slamaus]

Hi im fairly new to power bi and BI in general but thanks to this forum have mostly been able to figure enough out

For some reason my power query editor table is correct, but it is different and alot of values have been overwritten with a $0 in power desktop

Any advice?

Thanks

power query correctpower desktop incorrect

[v-xuding-msft · Accepted solution]

Hi @Slamaus ,

Is the value all 0 in the column of Sales Amount? According to your Figure, I found that the value of 0 in Figure 2 and the value in Figure 1 are corresponding based on the date of Posting Date. Can you please share more details and the sample files that we can check the issue ?

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.