Automatically fill field using M Language

[Anonymous]

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 query to fill in the team field automatically, placing the corresponding team

Can someone help me do this using M language?. Thanks

[Fowmy · Accepted solution]

@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 🙂

Website YouTube  LinkedIn

[TomMartens]

Hey @Anonymous ,

instead of messing around with "Fill Down" opeations I would first create a merge operation to pull the team column into table 2 (using the ID column as join column), after that I would execute the append operation.

Hopefully, this provides some new ideas on how to tackle the challenge.

Regards,

Tom

[amitchandak]

@Anonymous , In case DAX you cn have a column like

new column =
var _max= maxx(filter(table, [id] = earlier([id]) && not(isblank([team]))),[Team])
return
if(isblank([team]),_max,[Team])

[Anonymous]

Thanks, but  i need using languagem M in power bi query and i can not use dax.