Forum Discussion
Add custom column in multiple tables automatically
I have a power BI file with hundreds of tables. In a subset of those tables (all begin with "vw_card_") there is a common column named "spaid". I need to add a custom column to all of those tables th...
Anonymous ,
This may be a good quick question for ImkeF who is the meister of M.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
From my experience there is a very good chance that these tables should be appended together as one before being loaded to the data model. Then you'd also only have to add a column to one table.
Add a column to each of the tables as with an identifier before appending.