Forum Discussion
Solved
dimension table wild card
Hi, I have a group of manufacturers that fit into three categories: Buying Group Preferred "All Others" Right now, my dimension table has vendors in categories 1 and 2. Is there a way ...
You need to create the table that has the same columns as your dimension table.
Then, for each column, add values which indicate that it's Unknown or N/A.
One way you can accomplish this is with Enter Data:
Cheers!
Nathan
gellismyers - In Power Query M script, you could use Table.InsertRows to add a default row to your dimension table.
More interface-friendly way, also in Power Query: Add a new table with your single row, then Append it to your dimension table.
Okay, I will do a little research to figure out how to do that. I am a relatively new user but I've learned a lot.
Thanks a ton!