Forum Discussion
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...
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.
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
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
is it possible to put a criteria on this? Like day after?
If you have 2 tables one that includes name and birthdates and another includes just dates and you want to count dates that are after the birthdate of each row