Combining values from a field and filtering into rows

Question

Hey everyone,Here is some sample data of what I am trying to create..Let's say I have the field "Work Orders".. using the column "PrimaryIncidentType"&nbsp;(Workorder[PrimaryIncidentTypeName]&nbsp; is the exact field name)inside this field can containAT - PMAT - DMAT - EMCT - PMCT - DMCT - DMDC - PMDC - DMDC - EM (this goes on like 3 more times)Is there a way to get just the PM in a row named PM and contains all of the data just for the PMs?&nbsp; Same with others, here is my goal below&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jan&nbsp; &nbsp; &nbsp;Feb&nbsp; &nbsp; March&nbsp; etc etc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DecPM&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $20&nbsp; $10&nbsp; &nbsp;etc etcDMEMThanks!

v-easonf-msft · Accepted Answer

Hi,&nbsp;thomas_coltrain&nbsp;
You can try to add another calculated column to category these data rows&nbsp;,then apply this field to a matrix row.
Calculated column =
SWITCH (
    TRUE (),
    CONTAINSSTRING ( Workorder[PrimaryIncidentTypeName], "PM" ), "PM",
    CONTAINSSTRING ( Workorder[PrimaryIncidentTypeName], "DM" ), "DM",
    CONTAINSSTRING ( Workorder[PrimaryIncidentTypeName], "EM" ), "EM"
)

&nbsp;
Best Regards,Community Support Team _ Eason

Forum Discussion

Combining values from a field and filtering into rows

2 Replies

Related content

Tables combine

Filter combinations

Combined conditional filtering

Power Query combining NULL values

Combine values from multiple rows