Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi there, my first time on the site and posting 🙂
I'm a beginning user of power query and stuck in a situation where after joins from previous tables and transformations, my combined data set has some records where their Level 4 director didn't join/resolve because they are new employees and aren't in the monthly table yet.
Level 4 Director | Resource Name |
Vivek Mallina | Praneeth Pasam |
null | Samir Ulavapalli |
Vivek Mallina | Tushar Banthia |
Paulo Merritt | Tina Somburanasin |
null | Lisa Shankar |
... I've used a reference query to show me the names of the resources who's names aren't resolving to a Level 4 Director, and I was thinking of creating a separate table to serve as a lookup for replacing the null above, reading something like...
Resource Name | Level 4 Director |
Samir Ulavapalli | Vivek Mallina |
Lisa Shankar | Vivek Mallina |
...so I could use some M-Code or something like it to lookup the null's from the earlier table and end up with these "overridden" values so I don't have null's:
Level 4 Director | Resource Name |
Vivek Mallina | Praneeth Pasam |
Vivek Mallina | Samir Ulavapalli |
Vivek Mallina | Tushar Banthia |
Paulo Merritt | Tina Somburanasin |
Vivek Mallina | Lisa Shankar |
...and help or hints would be GREATLY appreciated!
NewStep=Table.ReplaceValue(PreivousStepName,each [Resource Name],"",(x,y,z)=>ReferenceTable{[#"Resource Name"=y]}?[Level 4 Director]? ??x,{"Level 4 Director"})
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
8 | |
7 | |
6 |