Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
@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])
Thanks, but i need using languagem M in power bi query and i can not use dax.
User | Count |
---|---|
92 | |
86 | |
66 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |