Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Seperating by text contains

Hi,   So I'm looking at setting up a new dashboard for a workflow that will be composed of tasks of the same work item type, for this reason I will be unable to filter by this alone. Am I able to c...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,
    Thanks for FarhanJeelani  reply, here is a realization version.
    Sample data

     

    Create a calculate table

    Filtered Table = 
    FILTER(
        'Table',
        CONTAINSSTRING('Table'[Project], "A")
    )

    Final output

     

    Best regards,
    Albert He


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly