Forum Discussion
Query result doesn't match returned data
Okay, so it seems the numbers appearing were as a result of the values being numerical.
My initial attempt at changing the format lead to frustration because I didn't realise that the report doesn't automatically update the format of any data displayed until you deselect and re-select all the columns.
A search of Stack Overflow yields the following possible answer:
https://stackoverflow.com/questions/50321954/power-query-merged-query-returning-incorrect-result
But I haven't applied a sort or anything to either of the offending columns.
so now I'm even more confused.
😕
Okay, so it seems the numbers appearing were as a result of the values being numerical.
My initial attempt at changing the format lead to frustration because I didn't realise that the report doesn't automatically update the format of any data displayed until you deselect and re-select all the columns.