Forum Discussion
Automatically fill field using M Language
Hi, I have a table below: and i have a second table: I need to join the two tables in one table. I used: and i got: But, now I need the power bi que...
Anonymous
Check the attached file please: After Appending as you did, you need to add the following step:You can download the file: HERE
= Table.ReplaceValue(#"Appended Query",null, each let x=_[ID] in Table.SelectRows(#"Appended Query", each [ID] =x and [TEAM] <> null)[TEAM]{0},Replacer.ReplaceValue,{"TEAM"})________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply š
Anonymous
Check the attached file please: After Appending as you did, you need to add the following step:
You can download the file: HERE
= Table.ReplaceValue(#"Appended Query",null, each let x=_[ID] in Table.SelectRows(#"Appended Query", each [ID] =x and [TEAM] <> null)[TEAM]{0},Replacer.ReplaceValue,{"TEAM"})
________________________
If my answer was helpful, please click Accept it as the solution to help other members find it useful
Click on the Thumbs-Up icon if you like this reply š