Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Measure that generates a list in text format based on certain criteria

Hi all,   I have a data table similar to the below:   Fruit Quantity Apple 12 Pear 2 Banana 5 Orange 7 Kiwi 2 Melon 3 Grapefruit 4 Peach 1   I need to cre...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , Hope Quantity is a column

     

    then

    Concatenatex(Filter(Table, Table[Quantity] <3) , Table[Fruit])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , Hope Quantity is a column

 

then

Concatenatex(Filter(Table, Table[Quantity] <3) , Table[Fruit])

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks!