Replacing values in Power Query

[sryair]

Hey

I grouped different values in the query
Some of the column headings are in dd/mm/yyyy date format
I am trying to change to another format so that the value is recognized as text for example 01.24.2024

I understand that I need to loop over each table in the query but Unfortunately without success

something like - .... each Text.Replace(_,"/","-")

Thanks in advance

PQ.jpg

[Kaper]

There is a chance that the dates are stored in date not in text format, because they are left-aligned (I noted your location: israel, so you use right-to-left arrangement).
If that hint is not enough, see yellow box above and add just 3-4 tables sample data (not your real data, but similar data where there are your dates

[romperstomper]

I assume those are meant to be column headers, so you'd probably want to promote the first row to headers, then you can use Table.TransformColumnNames

[sryair]

Thank you

The query accepts dates as column headers from different sheets in the file and should
Consolidate all sheets into one new sheet

When the dates are in the format dd.mm.yyyy they are probably recognized as text and go to the new sheet like I wanted.

When the dates are in the format dd/mm/yyyy they are recognized as a date and do not go to the new sheet as I wanted

I understand that i need to loop over each table separately and replace "/" with "." Then the query will work as I want

In the attached file you can see that the columns with a date with format dd/mm/yyyy are loaded into the output from the query without the column name as date but exist as Column4, Column3...

Thanks again

[romperstomper]

Change the first added custom step to:

Please Login or Register  to view this content.

[sryair]

Thank you

Works great!!!!

[romperstomper]

Glad we could help, and thanks for the rep.