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

Hi Tom:

 

Yes, actually that does work, but I think I've failed to illustrate the whole problem.

 

There will be many records that have [Action Parts] which are 1 .. so I would not be looking for them to be TRUE but will be in your example because it's SUMing them. 

 

Having just run it, I have Users who have many records with only 1 Action Part that are coming up TRUE just because the SUM of all the 1 parts.

 

Apologies for the oversight, and thank you for the help, especially if there's a way around this new part.

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.