Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi,
I'm struggling for some time on this problem. I have two fact tables with Event ID and Date. If the Event ID and Date from Table 2 are equal to those in Table 1, I can assume the event is the same so I need to extract the Location information from Table 2 to the same event in Table 1. If the event in Table 1 isn't in Table 2, Location information is left blank.
Can you help me to develop a DAX function to this new column which solves my problem?
Example:
Table 1:
Event ID | Date |
1 | 04/03 |
1 | 04/01 |
5 | 04/01 |
12 | 04/01 |
12 | 04/02 |
Table 2:
Event ID | Date | Location |
1 | 04/03 | A |
1 | 04/02 | B |
5 | 04/02 | A |
12 | 04/02 | C |
Desired Table 1:
Event ID | Date | New column - Location |
1 | 04/03 | A |
1 | 04/01 | |
5 | 04/01 | |
12 | 04/01 | |
12 | 04/02 | C |
Thanks so much!
Solved! Go to Solution.
@Anonymous , Create a new column in table 1
New column - Location = maxx(filter('Table 2','Table 2'[Event ID] = 'Table 1'[Event ID] && 'Table 2'[Date]= 'Table 1'[Date]),'Table 2'[Location])
@Anonymous , Create a new column in table 1
New column - Location = maxx(filter('Table 2','Table 2'[Event ID] = 'Table 1'[Event ID] && 'Table 2'[Date]= 'Table 1'[Date]),'Table 2'[Location])
User | Count |
---|---|
64 | |
59 | |
47 | |
33 | |
32 |
User | Count |
---|---|
84 | |
75 | |
56 | |
50 | |
44 |