Expression.Error: There is an unknown identifier. Did you use the [field] shorthand for a _[field] o

Hi Toast36 

Thank you for reaching out to the Microsoft Community Forum.
 
A special thanks to dufoq3 for responding on this topic.

It looks like the issue arises from a cyclic reference when filtering the InventoryDimension table using the Sales table.

Try buffering the Sales table before using it for filtering: 

let

    Source = Sql.Database("sql1.database.windows.net", "db1", [CommandTimeout=#duration(0, 5, 0, 0)]),

    Sales = Table.Buffer(Source{[Schema="RPT", Item="Sales"]}[Data]),

    InventoryDimension = Source{[Schema="RPT", Item="InventoryDimension"]}[Data],

    SalesKeys = List.Distinct(Sales[Inventory Dimension Key]),

    FilteredInventory = Table.SelectRows(InventoryDimension, each List.Contains(SalesKeys, [Inventory Dimension Key]))

in

    FilteredInventory

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.


Thank You