Hi Mynda, Catalin,
Need your expertise on another effective method to do that
Basically I got a list of dates which daily will be updated, and the latest date need to be inserted to each record in another table ( see my sample table attached)
I think my method quite primitive in power query using transpose and merge with "|" then append to the other table, use split to column > choose row to have all the records with all the dates.
is that a way to do it directly using M code ?
The method I use apply to my real case took very long to run with just 500 records (about 3-5 mins).....
Thank you very much
Hi Chris,
Watch session 7.08 on expanding rows. You need to do the same thing except you simply convert your Dates table (called Source) to a List (Transform tab > Convert to List).
Then add a Custom Column that references this query e.g.:
=#"Source"
Then expand to rows.
Mynda
Hi Mynda,
where is session 7.08 ?
Yes from the dates after converting to List already, you mean create a custom column in table 2 to reference to the list ? can illustrate further how to do it ? what is the code in the custom column ?
thank you !
Sorry, I mistook you for one of my course members.
The formula for the custom column is already stated above. You add the custom column to the table containing the names. After adding the custom column, you expand the column 'by rows' by clicking the double headed arrow on the filter button of the custom column.
You should take my Power Query course 😉
Mynda
Hi Mynda,
Got it and thanks for you guidance
