Forum Discussion
Need a reference to certain functions, please!
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
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
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 :(
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