Hello guys,
I have a data set with a column that contains text and numbers. the dataset is linked to power query for transformation and auto-update then to pivot table.
the sata set is in a table format.
the problem that i have is that power query gave that column a text format. so when i create a pivot table with the text within the column is fine. but the pivot table don't detect the numbers !!!
is there any solution to this please! i can't split the column in question. the data set is being received from a lot of people outside my company and therefore , the colum will always have text and numbers
thank you guys
I have a data set with a column that contains text and numbers. the dataset is linked to power query for transformation and auto-update then to pivot table.
the sata set is in a table format.
the problem that i have is that power query gave that column a text format. so when i create a pivot table with the text within the column is fine. but the pivot table don't detect the numbers !!!
is there any solution to this please! i can't split the column in question. the data set is being received from a lot of people outside my company and therefore , the colum will always have text and numbers
thank you guys
