Forum Discussion
Solved
Blank cells in Table visual
Hi, I have a table called "Team_Names" with 2 columns: "Full_Name" and "Team_Level" I then have my main table that also has "Team_level" and is connected based on that. I am trying to crea...
Do all the team names exist in Team_Names but with blank full names?
If so use Power Query to replace null values with "Open" and then only use team names and full names from that table (we call it a dimension).
If they don't all exist you'd have to do some more work in power query. Roughly...
1) Duplicate main table.
2) Remove all columns except for
team name.
3) Remove duplicates.
4) Merge join this onto your original name table.
5) Expand the column you get to retrieve full names.
6) Replace nulls with "Open".
7) Set your original name table to not load.
😎 Recreate joins with new table.
non ho capito. posso avere una delucidazione?