Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

DAX to replace value with another in same column depending on 2nd column

Hey all,   I have a curious problem due to the way data I am using is stored.   I have the table below . And I need to replace the ID (column a) of all the rows where Level is = 5, with the ID...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    Anonymous Could you please check and confirm... whether the data contains same idea (duplicates) at same level (in this case it is 4). Even though it has a different ID.

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous Please try this as a New Column

 

NewID = 
VAR _CurrentIdea = Test178CondReplace[Idea]
VAR _Level4ID = LOOKUPVALUE(Test178CondReplace[ID],Test178CondReplace[Idea],_CurrentIdea,Test178CondReplace[Level],4)
RETURN IF(Test178CondReplace[Level]=5,_Level4ID,Test178CondReplace[ID])

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hey PattemManohar

     

    Thanks for the suggestion. I'm getting the same error. 

     

     

    NewID = 
VAR _CurrentIdea = ImplementationLevel[Idea]
VAR _Level4ID = LOOKUPVALUE(ImplementationLevel[ID];ImplementationLevel[Idea];_CurrentIdea;ImplementationLevel[Level];"4")
RETURN IF(ImplementationLevel[Level]="5";_Level4ID;ImplementationLevel[ID])

    I've put the Levels in "" as they are formatted as Text (elsewhere I don't want them to be treated as numbers).

     

    Why does it return multiple values? ID column is unique values.

    • PattemManohar's avatar
      PattemManohar
      Icon for Community Champion rankCommunity Champion
      7 years ago

      Anonymous Could you please check and confirm... whether the data contains same idea (duplicates) at same level (in this case it is 4). Even though it has a different ID.