Forum Discussion
Query changes
Hi Pucca121,
Select 'Edit Queries' from arrow down.
Open your power query code via clicking on 'Advanced Editor'
In your code, you just need to add the highlighted part. You should replace the #"Changed Type" and "Date" with your own scenario.
Regards,
Yuliana Gu
Hello MarcelBeug
Where do I put this code? And I don't understand what is my PreviousStep.
I never did this type of tranformation in the query editor.
Thank you so much for your help!
P.
Hi Pucca121,
Select 'Edit Queries' from arrow down.
Open your power query code via clicking on 'Advanced Editor'
In your code, you just need to add the highlighted part. You should replace the #"Changed Type" and "Date" with your own scenario.
Regards,
Yuliana Gu
haaa ok! Much clearer now, thank you!!
P:
You need to add a comma at the end of your line, numbered 17.
It doesn't work -...-
#change type is the name of the column ?
#date is the category ?
and what did you put behind the "=" sign?
Do you have "to close and apply" to make it work and see a change in the column ?
Thank you so much!
Also notice that the identifier after "in" must be the last step name before "in".
