Forum Discussion
Question with Transforming Data in Power Query
Can you do some sort of Lookup Value in Power Query instead of using like a DAX code to create a table from just the report view?
To do a lookup in Power Query use:
LookupTable{[KeyColumn = "SomeValue"]}[DesiredColumn]
Add a ? to the end if the lookup may fail (in which case you get null)