Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm trying to create a function that reutrns a list based on the value of another column, but for the life of me can't figure out something seemingly basic. Hopefully you can help...
So I have a table that's basically this:
Id | Condition A? | Condition B?
1 | TRUE | FALSE
2 | TRUE | TRUE
3 | FALSE | TRUE
So my function should return the list of Id's where the condition is true, if I pass "Condition A" it should return {1, 2}. B should return {2, 3}. So this is what I have so far.
= let ListValuesByCondition= (DataTable as table, ReturnColumn as text) =>
Table.ToList(Table.SelectColumns((Table.SelectRows(DataTable, each ([#"Condition A?"] = true))), ReturnColumn))
in ListValuesByCondition
= FN_ListValuesByCondition(#"My Table", "Id")
But I want to pass the condition column ( ex: [#"Condition A?"] ) as a variable. And making it type list return nothing. Sounds like it's something obvious, but I haven't had much luck finding solutions. Thank you in advance!
Solved! Go to Solution.
Figured it out shortly after posting, but here's the solution in case anyone runs into the same.
So we're actually referencing a field instead of a column, and we can't use brackets since it will take the literal of the variable name. So instead we need to use Record.Field. It should look like:
= let ListValuesByCondition= (DataTable as table, ReturnColumn as text, ConditionColumn as text) =>
Table.ToList(Table.SelectColumns((Table.SelectRows(DataTable, each (Record.Field(_, ConditionColumn) = true)), ReturnColumn))
in ListValuesByCondition
= FN_ListValuesByCondition(#"My Table", "Id", "Condition A?")
Figured it out shortly after posting, but here's the solution in case anyone runs into the same.
So we're actually referencing a field instead of a column, and we can't use brackets since it will take the literal of the variable name. So instead we need to use Record.Field. It should look like:
= let ListValuesByCondition= (DataTable as table, ReturnColumn as text, ConditionColumn as text) =>
Table.ToList(Table.SelectColumns((Table.SelectRows(DataTable, each (Record.Field(_, ConditionColumn) = true)), ReturnColumn))
in ListValuesByCondition
= FN_ListValuesByCondition(#"My Table", "Id", "Condition A?")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |