Need a reference to certain functions, please!

[aszpic]

Hello everyone,

I am pretty new to Power BI (sorry).

I am looking for a site that tells me the functions to do "basic" management of tables, for example:

 - Creating a calculated table with a column that is composed of the union of 2 columns of different tables (the function UNION only works for full tables...)

 - Adding a new row to a table and removing rows from tables (probably calculated table?) dinamically, for example every time I find a condition on another table

Is this possible to do without having to learn "M"?

thanks in advance! Cookies for the best answer!

EDIT: UNION() worked. Still looking for the way to add rows to this calculated table! Thanks!

[Anonymous]

Hi @aszpic，

Could you please share sample data of your table and describe more details about that what condition it should meets when adding new row?

Thanks,
Lydia Zhang

[aszpic]

Let's say, "for each time a number "2" appears in a table, I add a new row in another table (and I say where the data in each cell comes from)".

So for example I have this tables :

TABLE 1
Codes	Number
A	1
B	1
C	2
D	2
E	1

TABLE 2
Codes	type	data 1	data 2
R	"original"	original data
S	"original"
T	"original"
U	"original"

And the result is adding rows to TABLE 2, so it results as the following:

TABLE 2
Codes	type	data	data
R	"original"	original data
S	"original"
T	"original"
U	"original"
C added	"added"	new data from other tables
D added	"added"

Probably what I can do is to make a new temporary table with just the rows "C added" and "D added" and then join it with TABLE 2. I just don't know how to do that 😞

[Anonymous · Accepted solution]

Hi  @aszpic,

I am afraid that you are not able to achieve the above requirement in Power BI Desktop with dynamical function. The easiest way is to create a query from Table 1 with specific conditions that has same structure as the table 2, Then use "Append Queries" to append table 2 and the newly created query.

Thanks,
Lydia Zhang