Query changes

[Pucca121]

Hello !

I would like to change the hour in the query. How can I do it?

Thank you 🙂

[v-yulgu-msft · Accepted solution]

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

[MarcelBeug]

There are many ways to change the hour. What would be the desired result?

The solution may depend on wether any time zones are involved or not.

[Pucca121]

Only one time zone is involved. I would like to put it at 00:01:00 (one minute past midnignt)

Thank you

P.

[v-yulgu-msft]

Hi @Pucca121,

As @MarcelBeug suggested, this query code works fine in my test, I could get the desired result. If it also apply to your scenario, please kindly mark it as an answer so that someone else having similar requirement can find the solution more easily. If not, please feel free to ask.

Regards,
Yuliana Gu

[MarcelBeug]

In the query editor (M) you can add a duration of 1 hour and 1 minute, e.g. with the following code, in which "PreviousStep" is the name of your previous step in the query code:

= Table.TransformColumns(PreviousStep,{{"DateTime", each _ + #duration(0,1,1,0), type datetime}})

[Pucca121]

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.

[v-yulgu-msft · Accepted solution]

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

[Pucca121]

@v-yulgu-msft

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!

[v-yulgu-msft]

@Pucca121

Regards,
Yuliana Gu

[MarcelBeug]

Also notice that the identifier after "in" must be the last step name before "in".

[Pucca121]

 Hello!

@MarcelBeug@v-yulgu-msft

I made the changes and it returned me this error. Any ideas why?

Thank you very much

P.

[MarcelBeug]

Apparently you either overlooked or misunderstood my previous post.

Just change the identifier after "in" to #"Renamed Columns".

[Pucca121]

@MarcelBeug

 I modified like this and it returned me this error -.....-

Thank you so much for your time!

[MarcelBeug]

In the last step you use function Table.RenameColumns. This should be Table.TransformColumns.

[Pucca121 · Accepted solution]

@MarcelBeug

It worked. I will see if my problem is resolved 🙂

Thank you sooo much!

P.

[Pucca121]

@MarcelBeug@v-yulgu-msft

Thank you so much for helping me! It worked 🙂

[Pucca121]

haaa ok! Much clearer now, thank you!!

P:

[Pucca121]

Hello again @v-yulgu-msft and @MarcelBeug

I have this error. Why?

Thank you

P.

[MarcelBeug]

You need to add a comma at the end of your line, numbered 17.

[Pucca121]

@MarcelBeug@v-yulgu-msft

I did that. It doesn't work.... Do you know why?