Forum Discussion

faheem_Latif_BI's avatar
faheem_Latif_BI
Icon for Helper I rankHelper I
3 years ago
Solved

dynamic LIST of values in MCODE

Hi GURUS, hope you are doing good ! This is my MCODE which is working fine.   Sql.Database(DataSource, Database, [Query="      SELECT * FROM [GroupFinance].[Voyager Intercompany Journal Data]  ...
Need Help
  • artemus's avatar
    artemus
    3 years ago

    You can use:

    where [Entity Code] IN ('"&Text.Combine(PropertyCode, "', '")&"')
artemus's avatar
artemus
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

You can use:

where [Entity Code] IN ('"&Text.Combine(PropertyCode, "', '")&"')