Forum Discussion
jlarques
Helper V
Helper VAdd records by category
Hi community, I have another challenge. I want to add all records of the same category, but first, I need to find which category it belongs to in the description column. When I find it, then I have ...
measure =
=IF(
SUMX(TableName,
FIND(
UPPER(TableName[Category]),
UPPER(TableName[Description])
,,0
)
) > 0,
SUM(TableName[Quantity]),
BLANK()
)
mh2587
Super User
Super Usermeasure =
=IF(
SUMX(TableName,
FIND(
UPPER(TableName[Category]),
UPPER(TableName[Description])
,,0
)
) > 0,
SUM(TableName[Quantity]),
BLANK()
)
