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.
Okay,
Is there a process by which I can return an array of values based on matching parameters (similar to that of a lookup function)? Then, if that's possible, is there another process in which I can search through that array to check to see if a specific value exists?
Thanks!
Jonathan
Hi @Anonymous,
You can try out the function "values" and operator "in" like this.
Column = IF ( [Item] IN VALUES ( 'Table4'[all] ), "Yes", "No" )
Best Regards,
Dale
Thanks @v-jiascu-msft, this helps for the latter half of the question.
But I'm initially wondering how do I get an array of values based on matching values? How can I get an array of values (and "store" them as a variable) based on a vlookup for example? So rather than capturing only a single value that matches particular criteria, but multiple values.
Hi @Anonymous,
Can you share a sample and the expected result please? Maybe you can find out the solution in this demo.
Possibility 1. Lookup values and create an independent table.
Table = FILTER ( 'Table1', 'Table1'[Column1] IN VALUES ( Criteria[Column1] ) )
Possibility 2. Use as a variable.
Measure = VAR var_a = FILTER ( 'Table1', 'Table1'[Column1] IN VALUES ( Criteria[Column1] ) ) RETURN CONCATENATEX ( var_a, [Column1], "-" )
Best Regards,
Dale
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |