Forum Discussion
Fill a column based on a value in two other columns
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])))
Community Champion"Mutuca" and "Pico" has different Response ID as per the screenshot.
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
- PattemManohar
Could you please post your expected output based on the Input screenshot or any sample input & output data will also be fine..
It should look like this after adjustments:
- PattemManohar
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