Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 to add the quantity to the rigth category.
How can I do that?
Thanks for all your help and support.
José Luis
Solved! Go to Solution.
measure =
=IF(
SUMX(TableName,
FIND(
UPPER(TableName[Category]),
UPPER(TableName[Description])
,,0
)
) > 0,
SUM(TableName[Quantity]),
BLANK()
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
measure =
=IF(
SUMX(TableName,
FIND(
UPPER(TableName[Category]),
UPPER(TableName[Description])
,,0
)
) > 0,
SUM(TableName[Quantity]),
BLANK()
)
Did I answer your question? If so, please mark my post as a solution!
Proud to be a Super User!
User | Count |
---|---|
85 | |
85 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |