Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |