passing a list to conditional statement

Question

hi all,i have two projects that need similar concept.&nbsp;&nbsp;One is where i need to add missing client codes. The source data has had fields that have been repurposed over time.&nbsp; At least 90% of the clients have codes in one of the 5 columns,&nbsp;&nbsp; i have a market list where I would normally merge to table.&nbsp; Instead I want to evaluate the market list against these columns and if value exists return it to column otherwise leave blank.&nbsp;&nbsp; Was going to merge columns for conditional statement&nbsp;and then&nbsp;expand.&nbsp; Found Imke&nbsp;idea&nbsp;to unpivot the columns&nbsp;and&nbsp;re-pivot after&nbsp;performing conditional &nbsp;statement.&nbsp;&nbsp;&nbsp; I have found several options to pass lists as filter arguments.&nbsp; I need all records to return.&nbsp; My attempt to parameterize conditional statement returned all nulls.&nbsp;&nbsp;The second project is similar in that i need to identify ads placed in sports games.&nbsp; We have a daypart field for sports but is optional so have a lot of data that fell into prime...every program during prime time tv.&nbsp;&nbsp;No uniformity in&nbsp;progam naming and abbreviations.&nbsp; huge file.&nbsp; anyway i have compiled lists of games, leagues, teams, etc...&nbsp; i need to categorize the records for easy filtering.&nbsp; i need to identify sports, basically that would be any record where any item in the list shows up.&nbsp; from there i need to specify the game in one filter, the teams in next filter, leagues, etc....&nbsp;&nbsp;if value = {list of criteria} then {list of criteria value} else null&nbsp;just not sure how to pass the value to the conditional statement.&nbsp;&nbsp;thanksTheresa

v-frfei-msft · Answer

Hi&nbsp;Anonymous ,
&nbsp;
Please refer to this case and hope it can help you.
https://community.powerbi.com/t5/Desktop/Pass-a-list-as-filter-argument-in-Power-Query/td-p/149101&nbsp;
&nbsp;
If it doesn't meet your requirement,&nbsp; Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
&nbsp;

anonymous · Answer

Hi,&nbsp; I apologize.. just saw message this am.&nbsp;Kinda sorta on vacation, so probably not the best time to submit a request.&nbsp;I have a file ready to load but let me test this potential solution first.&nbsp; &nbsp;Thx T

anonymous · Answer

ok.&nbsp; I had seen that topic before i posted.&nbsp; they are filtering data.&nbsp; I am wanting to categorize the data for future filtering.&nbsp;&nbsp;&nbsp;tried playing around with the parameters and just&nbsp;confused myself.&nbsp; &nbsp;let me see if i can figure out how to load the sample file for you to see.

anonymous · Answer

this is my first attempt at sharing a link, so we will see how it goes.

i keep pasting but can't see anything. The message shows some placeholders but that is it.

Please let me know if this come thru on that end. Thx T

anonymous · Answer

Sample File link&nbsp;&nbsp;&nbsp; ok&nbsp; here's the link to a very truncated/altered file.&nbsp; i had to recreate the function where i was passing a parameter to the conditional statement.&nbsp;&nbsp; all the result values returned as&nbsp;null..&nbsp;&nbsp; i added a client code of&nbsp; XXXX that should return a value on the altered data.&nbsp;&nbsp;the goal is to dynamically assign the client code if it is found in the values list.&nbsp; on the other process, I want to dynamically categorize the data, with each category becoming more specific.&nbsp; in VBA I would just create a variable and loop.&nbsp; I am still getting tripped up on the way variables work in other languages versus PQ.&nbsp;&nbsp;&nbsp; Thx T

Forum Discussion

passing a list to conditional statement

6 Replies

Related content

Dax IF/AND Statement with Null condition

IF statement and conditions

How do I pass parameters to my SQL statement?

Condition Statement

Custom Tooltip Not Passing Single-Country Filter Context When Y Axis Uses Conditional Logic