Different results below table in Query Editor

[elliotdixon]

Hi,

I am getting a different number showing in the detailed view of the query editor pane when selecting a line. Cannot work out why.

This is having an affect on my calculations as it seems to be using the number below.

If I just select the box the number is the same.

This seems really odd. Any ideas would be appreciated.

the colum is just a decimal number column.

Cheers

[v-jiascu-msft]

Hi @elliotdixon,

They seem two different records. Please look at the snapshot below.  

1. The times 1 and 2 can't be found in the source you think.

2. It's "Driving" in the record while it's "Lunch break" in the source.

Please share a sample that can show up the issue.

Best Regards,
Dale

[HotChilli]

Can't really tell from the picture because that's not the only field that's different.  Look at the field beside it("Driving..."), and the dates on left and right.

Can you upload a picture of the whole view so that we can see it (with row 22 selected)

OR attach a link to the pbix?