Forum Discussion
Group by not picking up data
Hi. I have built a report that was previously working fine. I have done a data refresh and for some reason, the group by is not working properly. Data is confidential so I can't share but as an ...
Hi. I am not using the table visual. The issue is within power query editor when I upload new data for June.
It seems to be a problem with data grouping. For example, all the entries for one patient correctly group for each month up to and including May. However, when I refresh the data, I am getting 'null' values in the columns for location, todate start of month (which is a custom column that I built in) and weight change (which is what I was summing thr grouping on). Some patients it works absolutely fine and is returning all the relevant data but some it isn't. And where it isn't, it is only when it gets to June (which is the new data that I have refreshed for) is it returning 'null' values.