Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi folks,
I'm having problems to join two tables.
Ex:
I've these table: Project and Reports
Project |
abc |
def |
ghi |
jkl |
mno |
pqr |
stu |
vwx |
yz |
Project | Date (DD-MM-YY) | Report 01 | Report 02 |
ghi | 01/01/2020 | Y | N |
jkl | 01/01/2020 | Y | Y |
mno | 01/01/2020 | Y | Y |
pqr | 01/01/2020 | N | Y |
abc | 08/01/2020 | Y | N |
def | 08/01/2020 | Y | Y |
ghi | 08/01/2020 | Y | Y |
jkl | 08/01/2020 | N | Y |
mno | 08/01/2020 | Y | N |
abc | 15/01/2020 | Y | Y |
def | 15/01/2020 | Y | Y |
ghi | 15/01/2020 | N | Y |
jkl | 15/01/2020 | Y | N |
mno | 15/01/2020 | Y | Y |
pqr | 15/01/2020 | Y | N |
stu | 15/01/2020 | Y | Y |
vwx | 15/01/2020 | Y | Y |
yz | 15/01/2020 | N | Y |
And the result I need is
Project | Date (DD-MM-YY) | Status Report 01 | Status Report 02 |
abc | 01/01/2020 | Not Reported | Not Reported |
def | 01/01/2020 | Not Reported | Not Reported |
ghi | 01/01/2020 | Reported | Not Reported |
jkl | 01/01/2020 | Reported | Reported |
mno | 01/01/2020 | Reported | Reported |
pqr | 01/01/2020 | Not Reported | Reported |
stu | 01/01/2020 | Not Reported | Not Reported |
vwx | 01/01/2020 | Not Reported | Not Reported |
yz | 01/01/2020 | Not Reported | Not Reported |
abc | 08/01/2020 | Reported | Not Reported |
def | 08/01/2020 | Reported | Reported |
ghi | 08/01/2020 | Reported | Reported |
jkl | 08/01/2020 | Not Reported | Reported |
mno | 08/01/2020 | Reported | Not Reported |
pqr | 08/01/2020 | Not Reported | Not Reported |
stu | 08/01/2020 | Not Reported | Not Reported |
vwx | 08/01/2020 | Not Reported | Not Reported |
yz | 08/01/2020 | Not Reported | Not Reported |
abc | 15/01/2020 | Reported | Reported |
def | 15/01/2020 | Reported | Reported |
ghi | 15/01/2020 | Not Reported | Reported |
jkl | 15/01/2020 | Reported | Not Reported |
mno | 15/01/2020 | Reported | Reported |
pqr | 15/01/2020 | Reported | Not Reported |
stu | 15/01/2020 | Reported | Reported |
vwx | 15/01/2020 | Reported | Reported |
yz | 15/01/2020 | Not Reported | Reported |
Could anyone help me?
Tks!!!
Solved! Go to Solution.
Hi @Anonymous
Probably not the most elegant solution, but it does the job.
Please see the attached.
Hi @Anonymous
Probably not the most elegant solution, but it does the job.
Please see the attached.
It works for me!!
TKS!!!!!!!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |