Forum Discussion

HeideDeLange's avatar
HeideDeLange
Regular Visitor
2 years ago
Solved

Comparing field to data in another table power query excel

Hi all,   I am really hoping you can help me. I have tried everything that I could find in these forums, and I am most likely doing something wrong.  I use Power query in Excel.   I have a requir...
Need Help
  • HeideDeLange's avatar
    HeideDeLange
    2 years ago

    Hi all, Thank you for your suggestions. Neither helped because the Date information is in a cell in the workbook, that then gets sucked in to a query, however my data table and the Date table still live in different queries.

     

    However I did find a solution that works:

     

    Table.FirstValue(Date) did the job. 

    Thanks for your assistance!

HeideDeLange's avatar
HeideDeLange
Regular Visitor
2 years ago

Hi all, Thank you for your suggestions. Neither helped because the Date information is in a cell in the workbook, that then gets sucked in to a query, however my data table and the Date table still live in different queries.

 

However I did find a solution that works:

 

Table.FirstValue(Date) did the job. 

Thanks for your assistance!