Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated Column Identifier based on if a particular condition is satisfied in Data Table

Hi all, it's hard to put into words for the title what I'm looking for, but (hopefully) simpler in the DAX Really, what I'm looking to do is create a calculated column in my lookup table that wi...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Anonymous ,

    According to your description, I modify your sample data.

    Table1:

    Here's my solution. Create a calculated column.

    Multi-Part Person =
IF (
    SUMX (
        FILTER (
            'Table1',
            'Table1'[User Record] = EARLIER ( Table2[User Record] )
                && 'Table1'[Action Parts] <> 1
        ),
        'Table1'[Action Parts]
    ) > 0,
    TRUE,
    FALSE
)

    Get the correct result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

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

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

tackytechtom I wonder if a MAX function can plug in there and if it's greater than 1? I can't seem to get it to work

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Anonymous ,

According to your description, I modify your sample data.

Table1:

Here's my solution. Create a calculated column.

Multi-Part Person =
IF (
    SUMX (
        FILTER (
            'Table1',
            'Table1'[User Record] = EARLIER ( Table2[User Record] )
                && 'Table1'[Action Parts] <> 1
        ),
        'Table1'[Action Parts]
    ) > 0,
    TRUE,
    FALSE
)

Get the correct result.

I attach my sample below for reference.

 

Best Regards,
Community Support Team _ kalyj

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