Forum Discussion
dimension table wild card
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.
Sorry. I can't find any good info on this online. What would my single row table look like?
Thank you
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
Great, thank you. I will give it a shot.
Cheers,
Geoff