Amazing 👍. Thanks James and looking forward to more and more videos from you ❤
@williamarthur4801
Ай бұрын
That is brilliant, and I'm still working on understanding how it all fits together, but I did have a go myself, this did mean having a unique date or index column, then Table.SelectRows(
@AnilKumar-vi8oe
Ай бұрын
You are just amazing man, concepts and solutions you bring are out of the box...
@tonybatty504
Ай бұрын
Looks interesting but I'm going to have to work through that quite a few times to understand what is happening in each step.
@pamphlex
Ай бұрын
So in a record you squeeze 2 integers, 1 list and 1 table... Nice! I want you do it (same outcome) with nested LET, to really make a point.
@RonDavidowicz
Ай бұрын
Another great video, would like to hear the real-world situation that prompted this. Seems like a strange thing to need to accomplish.
@themolestones
Ай бұрын
amazing video
@gnsarathbabu
Ай бұрын
Hi Sensai, could you please let me know whether this is possible in pq I have two tables in powerquery One table -Custreview ProductId, customer-comments 100, it sucks 102, this is amazing Second table -custmoderate ProductId, lookupword, replaceword 100, sucks, not good 100,it, this 102,amazing,exemplary From Custreview table match Product Id with custmoderate table; if matched; take customer comments field from Custreview and replace lookupword with replaceword. One Product Id can have 100's of word that need to be replaced. Please guide me how to do it in powerquery.
@haroldmadrigal3671
Ай бұрын
How can you create a library of custom functions?
@basensei8699
22 күн бұрын
it's a good idea. i've seen some dudes create these online and make them available. maybe is hould start doing that also.
@larmondoflairallen4705
23 күн бұрын
I think the first step needs to be, "Make sure your data is sorted by date, in ascending order." If the data isn't presorted, the code won't work as expected.
Пікірлер: 12