dynamic LIST of values in MCODE

[faheem_Latif_BI]

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] 
    where [Entity Code] = '"&PropertyCode&"' 
    AND [Post Date] >='"&Fromdate&"' and [Post Date] <= '"&Todate&"'   "])

Now i want to add list of values in [Entity Code] using PropertyCode parameter.  

please help 

thanks in advance 

[artemus · Accepted solution]

You can use:

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

[ImkeF]

Hi @faheem_Latif_BI ,

I don't understand your request.

Please read the guidelines on how to post your questions to get them answered quickly and correctly:: help how to get your questions answered quickly - Microsoft Power BI Community