Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

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's avatar
    Watsky
    5 years ago

    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.

     

1 Reply

  • Watsky's avatar
    Watsky
    Icon for Solution Sage rankSolution Sage
    5 years ago

    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.