Forum Discussion
chemota
2 years agoNew Member
chatgpt cannot help me! (return value from another row that has another variable in common)
I need a DAX formula for Power BI that creates a new column (the new column will be called "columna") in a table. The table is named: "brickCrowd17 transactions_2" The new column will be called ...
j_ocean
Helper V
2 years ago- Split off an un-loaded copy of the table
- Filter to 20/21
- Drop all but lemonway_id and user_id
- Remove duplicates table-wide
- Group-by lemonway_id with an "average" on user_id, and a row count
- Change the "average" code to Text.Combine to get a concatenated list of users in that cell.
- Filter out row count 1 (the ones where there is no repeat)
- Merge this table back into a copy of your original matching on lemonway_id and expanding out your concatenated list of users.
Conversely in power bi you can use the original table to supply a matrix with lemonway_id and user_id as rows.