how can i make a list from reference column, with some keywords.
currently I can only do one action like in GIF which is fetching list from another table,
for example, when in a category I select more than one item, the list will display all lists of the category I selected.
this is formula which use for list :
select(Unit Price[Item],[Category]=[_THISROW].[Category])
Hi @ADAJALAN
What about:
SELECT(Unit Price[Item],
ISNOTBLANK(
INTERSECT([Category],[_THISROW].[Category])
)
)
that is the formula I use in the new virtual column like this photo,
to get a list item from the value in the category . column
OK.
And that works, or that doesn’t ?
which formula ?
it works, but only with one criteria i select from [category] column,
If I want to display a list of several criteria from the [category] column, for example [category]=Panel,Cable
Then the list will display a list of panels and cables
what do I have to do ?
Did you try my suggestion ?
I write it again, with a more explicit category name:
SELECT(Unit Price[Item],
ISNOTBLANK(
INTERSECT(
[CategoryColumn_FromUnitPriceTable],
[_THISROW].[CategoryColumn_FromCurrentTableIfEnumList])
)
)
doesn’t seem to be working
Assuming:
[_THISROW].[Category]
is an enumListTry:
SELECT(Unit Price[Item],
ISNOTBLANK(
INTERSECT(
LIST([Category]),
SPLIT(
CONCATENATE([_THISROW].[Category]),
" , "
)
)
)
)
Edit : correction of expression
awesome, it works…
or this also works
SELECT(Unit Price[Item],
ISNOTBLANK(
INTERSECT(
LIST([Category]),
[_THISROW].[Category])
)
)
and now i have a new problem, how can i download or export from this list ?
That’s another question.
I’m pretty sure you will find the answer at looking in previous posts on this community.
I suggest you post a new thread if you still don’t get it
Just in case that may help too:
Okay, no problem…
thanks for the help and advice.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
18 |