Hello,
I want to Select unique values from the same table to populate a dropdown, but with 2 criteria. I know it doesn't seem complicated but I've been all day and I can't find how to do it.
The case is like this:
I have a table of Products, the same product can be in several places with different characteristics. As I take the values from the same table, the same product is repeated many times for each location. What I want to obtain is the Key Id of the unique values of each product in each location.
Something like:
Loc1 ProductA
Loc 2 ProductA
Loc1 ProductB
and so, without product repetitions by agency.
Some help? From already thank you very much
Solved! Go to Solution.
You can add a new column « locProduct » with app formula:
IF(
IN([_This], tableName[locProduct]),
“”,
CONCATENATE([location], [product])
)
Then using this expression, you get the keys of unique entries:
FILTER(“tableName”,
ISNOTBLANK([locProduct])
)
You can add a new column « locProduct » with app formula:
IF(
IN([_This], tableName[locProduct]),
“”,
CONCATENATE([location], [product])
)
Then using this expression, you get the keys of unique entries:
FILTER(“tableName”,
ISNOTBLANK([locProduct])
)
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |