Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I need to merge one query and one table in Power BI. The table has duplications and I would like to keep them because of the logic. At below, you can find the simple example of what I am trying to do.
Unfortunately, I cannot use power query or merge function, because one of them is query. I need to do in Power BI / dax. I tried crossjoin, union,lookup but none of them solve the issue. Can anyone help me?
Thank you!
Gozde
Solved! Go to Solution.
Lookup is not working for my case, because of dublications. I don't want to look up according to engineer and location, because again dublication occurs. It can be that different engineer working in same location.
However, I found this solution:
I changed the input table into this:
Afterwards, I look group 1 and 2 seperately via lookup function. It worked 🙂
Regards,
Gozde
@Gozde,
Create the following columns in Table-2.
Lookupengineer = LOOKUPVALUE('Query-1'[Engineer],'Query-1'[Date],'Table-2'[Date])
Lookuplocation = LOOKUPVALUE('Query-1'[Location],'Query-1'[Date],'Table-2'[Date])
Regards,
Lydia
Lookup is not working for my case, because of dublications. I don't want to look up according to engineer and location, because again dublication occurs. It can be that different engineer working in same location.
However, I found this solution:
I changed the input table into this:
Afterwards, I look group 1 and 2 seperately via lookup function. It worked 🙂
Regards,
Gozde
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |