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
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