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)
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]),
...
Hopefully List
is what you're looking for.