Forum Discussion

gbrmdc's avatar
gbrmdc
Frequent Visitor
7 years ago
Solved

Fill a column based on a value in two other columns

Hello, everyone!   I'm working with a form that is automatically downloaded from a server and it consists of a table with responses from multiple different forms. Each row of the table is a dif...
  • PattemManohar's avatar
    PattemManohar
    7 years ago

    You need to add the column using that expression in "Data" pane using "New Column" NOT in "Power Query Editor".

     

     

    Also please note in the below expression LookupValue is name of the table I've stored sample data, in your case it should be your tablename. As LookupValue is a DAX keyword as well, that's why it was mentioned in single quote (I might have used another name to avoid confusion)

     

    Check = CALCULATE(MAX('LookupValue'[Answer]),FILTER(ALL('LookupValue'),'LookupValue'[Question]="Location" && 'LookupValue'[ResponseID] = EARLIER([ResponseID])))

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI gbrmdc,

 

If you mean fill column with answers column value and replace blank value as 'verify'. you can try to use below formula:

#"Added Custom" = Table.AddColumn(#"preview step", "custom", each if [Column1.answer] <> "" then [Column1.answer] else "verify")

>>which is the language of the table, verify = verificar and location = localidade/local

You can modify regional setting in options or choose advanced download option to choose a particular language version of power bi desktop.


Regards,

Xiaoxin Sheng

  • gbrmdc's avatar
    gbrmdc
    Frequent Visitor
    7 years ago

    Hello Anonymous!

     

    Thanks for your reply :)

     

    What I meant was create a new column and have the location answer (in the picture I sent, they are "Mutuca" and "Pico") replicated to the other lines with same Response ID number

     

    Is that possible?

     

     

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

      "Mutuca" and "Pico" has different Response ID as per the screenshot. 

      • gbrmdc's avatar
        gbrmdc
        Frequent Visitor
        7 years ago

        Hi PattemManohar,

         

        Yes, because they're associated with different form responses. What I need is to have the other lines with the same Response ID as "Mutuca" to say "Mutuca" instead of "Verify" in the Location or a new personalized column, the lines with same Response ID as "Pico" to say "Pico" and so on