Creating an extra column and assigning it with value based on conditions

[Anonymous]

Hi guys,

I wan't to create the last column 'extracolumn' by creating a measure using DAX. The column is a copy of name when the boolean value is true grouped by someidentification.

Help is appreciated!

id someidentification boolean name extracolumn
1 100 true test1 test1
2 100 false test2 test1
3 100 false test3 test1
4 200 true test4 test4
5 200 false test5 test4

[Watsky · Accepted solution]

Hey @Anonymous ,

Give this a try:

extracolumn =
VAR some = 'Table'[someidentification ]
RETURN
    LOOKUPVALUE (
        'Table'[name],
        'Table'[boolean], "TRUE",
        'Table'[someidentification ], some
    )

Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.