going to do here is i'm just going to get rid of this change column item so now it's not a number i'm just going to change it to text you may not have to do this i'm going to go to transform and then there's a nice little thing here that says convert to list bam but this isn't the format that i need i need a comma separated list of items because when i go into the where clause the in statement needs to be number comma number comma number so how do i get that kind of format let's go in advanced editor this is just me tinkering right i'm trying things let's see if we can get this to work when i was going through this on the call i had no idea if this would actually work but i'm trying this maybe it'll fail we'll try something else patrick was right there with me he was thinking the same thing and actually this became a race competition between patrick and i we were both on our machines trying to replicate this and so i was trying it on my end patrick was trying it on his end first spoilers i won it's already in list format so what i'm going to do here is URL_TOKEN the tooltips didn't come up here if you're in power bi desktop it'll actually give you the intellisense that tells you what it is but if we go back and look at our documentation the first parameter here is the list itself in this case the list is going to be the reference of this name on the left side and then we can add the separators just like that after each item in that list i want to add comma space and then just go through the list now what i need to do is change the in statement to be the last item in my list of function calls okay bam that's exactly what i want and at that point i told patrick i got it and we got really excited this could work you'll notice here that internet sales is broke at this point that's okay we're gonna do the same exact thing for currency go to transform we can go to convert to list go to the advanced editor again and this is where you actually have to convert it to text first let's back up this is what i mean by like trial and error just trying things sometimes you're gonna hit an error because maybe this is the first time you've done something and this is how you learn it let's change it to text and then we'll convert it to a list and then we will modify same thing we did before bam now we've got both of our lists here ignore the warning internet sales is still busted but now we're going to come in and we're just going to modify this part of it so again what i want to do is get these as a where clause in the select so i'm taking this merge which they used as a where i'm just going to insert it into this query statement so first thing i'm going to do is i'm just going to get a reference to those other queries this part's probably just not necessary but i'm doing it just for readability's sake so i'm adding currency list and then i've got promotion list so these are my references that i'll
NO_SEGMENT_TOKEN