Forum Discussion
faheem_Latif_BI
Helper I
3 years agodynamic 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]
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
You can use:
where [Entity Code] IN ('"&Text.Combine(PropertyCode, "', '")&"')
2 Replies
- artemus
Microsoft Employee
You can use:
where [Entity Code] IN ('"&Text.Combine(PropertyCode, "', '")&"') - ImkeF
Community Champion
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