Try something like this:
Is that something you can work with?![]()
let paramBusUnit = "North", txtBaseSQL = "select Projects_SV.* FROM Projects_SV Where Projects_SV.[Business_Unit_ID] = 'ABC'", txtSQL = Text.Replace(txtBaseSQL, "ABC", paramBusUnit) in txtSQL
Bookmarks