Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

counting rows from another table in Power Query (NOT DAX)

  Figure 2: Figure 3:   I have this table Figure 1, which I need to generate a new column able to count rows from another column(another table i.e. Figure 3) in power query simi...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi Anonymous 

     

    Ok, just follow the steps below.

    1.  While in Table1, go to Home ribbon and click on Merge Queries.
    2. Select Table2 and dates on both tables as below, this will add an extra column with Tables in it.

    3. Click on double arrow in your new column and follow the setup below.
     
    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

Mariusz's avatar
Mariusz
Community Champion
7 years ago

Hi Anonymous 

 

can you provide a small data samples reflecting both tables structure and based on this sample an expected outcome?

 

Best Regards,
Mariusz

Please feel free to connect with me.
Mariusz Repczynski

 

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    Hi Anonymous 

     

    So what is the outcome that you expect?

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      That I can count rows from table2 using based on date value, which is the same in both table1 and table2.

      I wanna count the rows in table2 Litra (how many of same kinds), the result is shown in table1.

      Though they have no relation like in DAX (I dont want it done in DAX).