Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 similar to using the calculate function in DAX shown in Figure 2.
In the end the counted rows in the Figure 1 (Table 1) will be unpivoted.
Solved! Go to Solution.
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.
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.
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
*I know this is an old thread but it's exactly what I'm trying to achieve!
I have tried exactly this approach (I thought this should be the solution before reading this post) but I get an incorrect value when there are no matches.
1. I have a table AuditRequestLog with a [Date Requested] column.
2. I build a separate table of a list of dates
3. I merge & aggregate the [Date] column of this table with AuditRequestLog, based on the [Date Requested] column
3a. I can see for an example an empty table for 17/11/2021
4. But when I expand, it still gets counted
I don't want to have to filter out the date table, as I want to be able to see zeroes. This is in Excel and I did consider a Date Table in Power Pivot but there is more than one date column in AuditRequestLog that I want to measure against.
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).
User | Count |
---|---|
17 | |
10 | |
9 | |
9 | |
8 |
User | Count |
---|---|
23 | |
18 | |
15 | |
13 | |
13 |