Forum Discussion

aszpic's avatar
aszpic
Frequent Visitor
9 years ago
Solved

Need a reference to certain functions, please!

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!

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
      aszpic
      Frequent Visitor
      9 years ago

      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 
      CodesNumber
      A1
      B1
      C2
      D2
      E1

       

      TABLE 2   
      Codestypedata 1data 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   
      Codestypedatadata
      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's avatar
        Anonymous
        Not applicable
        9 years ago

        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