Search code examples
powerbipowerquerym

How to reference another table in the Power BI query editor


Is it possible to reference another table using M in Power BI?

I have a list of files in TableA and want to compare the data with a list in TableB.

I have done this in DAX by using related and was wondering does M have a similar function?

= SEARCH(related(keywords[keyword]),main[text],1,0)

Solution

  • I struggled to find this information too.

    This is a snippet from a Power Query 'Advanced Editor' where I'm reading a minimum date from another table into a variable.

    let
        Source = #date(2015, 1, 1),
        MinDate = List.Min(TableName[Date]),
    ...
    

    Power Query List functions

    Hopefully List is what you're looking for.