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!

dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi HeideDeLange, check this:

 

Table1SingleDate

 

Output

let
    Table1SingleDate = #table(type table[Date of Extract=date], {{#date(2024,1,15)}}),
    Table2Data = Table.FromList(List.Dates(#date(2024,1,1), 31, #duration(1,0,0,0)), (x)=> {x}, type table[Expiry Date=date]),
    Ad_Check = Table.AddColumn(Table2Data, "Check", each if [Expiry Date] < Table1SingleDate{0}[Date of Extract] then "Before" else "After", type text)
in
    Ad_Check