Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

undefined

I am trying to create a calculated column in my table that uses multiple statements to determine what to display.   Expected outcome: This is what I generally want it to look like.  I want the Mat...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Anonymous 

    Not sure the data type and how your table is constructed but can you try the following column

    Matrix Priority =
VAR __Desc = 'Tasks/Inc''s Combined'[result.short_description]
VAR __Priority = 'Tasks/Inc''s Combined'[result.priority]
VAR __ClosedBy = 'Tasks/Inc''s Combined'[result.closed_by]
RETURN
    SWITCH (
        TRUE (),
        CONTAINSSTRING ( __Desc, "JDSS New" ), "Now",
        __Priority = 2
            && __ClosedBy = BLANK (), "Now",
        __Priority <> 2
            && __ClosedBy = BLANK (), "Next"
    )
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

Anonymous 

Not sure the data type and how your table is constructed but can you try the following column

Matrix Priority =
VAR __Desc = 'Tasks/Inc''s Combined'[result.short_description]
VAR __Priority = 'Tasks/Inc''s Combined'[result.priority]
VAR __ClosedBy = 'Tasks/Inc''s Combined'[result.closed_by]
RETURN
    SWITCH (
        TRUE (),
        CONTAINSSTRING ( __Desc, "JDSS New" ), "Now",
        __Priority = 2
            && __ClosedBy = BLANK (), "Now",
        __Priority <> 2
            && __ClosedBy = BLANK (), "Next"
    )