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 I need to diplay the maximun date based on 2 other criterias . 1 criteria is on Table 1 the other criteria is on table 2
For eample look for 'PLUM' in column called Trade (Table 1) and look for 'OUTSTANDING; in column called Status (Table 2) and diplay the MAX date for column called Appointment Date (Table 2)
Exampl of both tables and field for which I need the criteria applied to
Repair Table 1 | Appointments Table 2 | ||
Trade | Status | Appointment date | |
PLUMBING | OUTSTANDING | = MAX DATE |
hope this makes sense
Richard
Solved! Go to Solution.
Repair Table 1 | Appointments Table 2 | ||||
Trade | repair_id | repair_id | Status | Appointment date | |
PLUMBING | 4 | 4 | OUTSTANDING | 3/3/2019 |
you need to be able to have a relationship between your tables. I've added a sample field, repair_id, where all the appointments for a give repair would have the same repair id that the repair does. repair Id must be unique in table 1, and can appear many times in table 2.
Once you have this link you will be able to find the max date in table 2 for a given repair.
Help when you know. Ask when you don't!
Repair Table 1 | Appointments Table 2 | ||||
Trade | repair_id | repair_id | Status | Appointment date | |
PLUMBING | 4 | 4 | OUTSTANDING | 3/3/2019 |
you need to be able to have a relationship between your tables. I've added a sample field, repair_id, where all the appointments for a give repair would have the same repair id that the repair does. repair Id must be unique in table 1, and can appear many times in table 2.
Once you have this link you will be able to find the max date in table 2 for a given repair.
Help when you know. Ask when you don't!
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |