Forum Discussion

gbrmdc's avatar
gbrmdc
Frequent Visitor
8 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
    8 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])))

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

Could you please post your expected output based on the Input screenshot or any sample input & output data will also be fine..

gbrmdc's avatar
gbrmdc
Frequent Visitor
8 years ago

It should look like this after adjustments:

 

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

    Could you please try the following...

     

    Add a "New Column" using below expression...

     

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

     

    InputOutput

    • gbrmdc's avatar
      gbrmdc
      Frequent Visitor
      8 years ago

      Dear PattemManohar,

       

      Thanks for your help!

       

      I am getting a "token literal expected" error when I try to add this formula:

       

       

      If I click on "show error", it points to the first apostrophe on 'LookupValue'

       

      Regards,

      Gabriel

      • PattemManohar's avatar
        PattemManohar
        Icon for Community Champion rankCommunity Champion
        8 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])))