Hi,
I have data in a column of document numbers with the form: 'C11-123-xxx-123'. It is of type 'Any' in Powerquery. Yesterday I created a Pivottable with appropriate rows and columns to identify the data (it actually only returns a single entry at each data point). The measure MIN(qrySrc[Doc No]) worked perfectly (honest - I was surprised). Today it returns an error. Perhaps, when I created the table I didn't try to refresh it and that until I did so it was quite happy as I have a correctly populated table to show that it worked.
Does anyone have any idea why it may have worked and now doesn't. Or, does anyone know how I can get the Document Number returned to the data area of the form.
many thanks.
Peter
I have data in a column of document numbers with the form: 'C11-123-xxx-123'. It is of type 'Any' in Powerquery. Yesterday I created a Pivottable with appropriate rows and columns to identify the data (it actually only returns a single entry at each data point). The measure MIN(qrySrc[Doc No]) worked perfectly (honest - I was surprised). Today it returns an error. Perhaps, when I created the table I didn't try to refresh it and that until I did so it was quite happy as I have a correctly populated table to show that it worked.
Does anyone have any idea why it may have worked and now doesn't. Or, does anyone know how I can get the Document Number returned to the data area of the form.
many thanks.
Peter
