Forum Discussion
Select Rows From Another Tables With Unmatching Dates
Hello everyone, I had posted a message this morning and I thought I had found the solution but it seems that I still need help writing in PowerQuery. So, I remind my question, I had a table with...
Unfortunately I have the message that no column was found when I apply your solution as you can see on these screenshots
Do you know how I can fix it? Thank you very much for your intervention.
If you want to have a quick and useful answer, try to upload a file with the starting tables and the desired arrival table.
I didn't realize it was inside anotherfunction ( table.add.column)
try this inside the box of addcolumn (colonne personaliseé)
Table.SelectRows(tablename, (r)=>r[Currency Code] = [Currency Code] and r[Order Date] <= [Starting Date])