Forum Discussion

thomas_coltrain's avatar
thomas_coltrain
Frequent Visitor
4 years ago
Solved

Combining values from a field and filtering into rows

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" (Workorder[PrimaryIncidentTypeName]  is the ...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    Hi, thomas_coltrain 

    You can try to add another calculated column to category these data rows ,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"
)

     

    Best Regards,
    Community Support Team _ Eason

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

Hi thomas_coltrain 

 

Can you post sample data as text and expected output?
Not enough information to go on;

please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables

Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/