Forum Discussion

elliotdixon's avatar
elliotdixon
Responsive Resident
7 years ago

Different results below table in Query Editor

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

Need Help

2 Replies

  • HotChilli's avatar
    HotChilli
    Community Champion
    7 years ago

    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?

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    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.

    Different-results-below-table-in-Query-Editor

    Please share a sample that can show up the issue.

     

    Best Regards,
    Dale