Hi,

I have two tables pls refer the below tables . Table 1 and Table 2. There is no join between two tables.

Table 1:

Code Date ID Test Technology
ABC1 17-Dec-22 123 Pass Java
ABC2 17-Dec-22 135 Pass Java
ABC2 18-Dec-22 135 Pass Java
ABC3 18-Dec-22 156 Pass Java
ABC4 18-Dec-22 166 Pass Testing
ABC5 18-Dec-22 176 Pass Testing
ABC6 19-Dec-22 186 Pass Testing

Table 2:

ID Code Technology
123 ABC1 Java
135 ABC2 Java
156 ABC3 Java
166 ABC4 Testing
176 ABC5 Testing
186 ABC6 Testing

Expected output in the report:

Code Date ID Pass Or Fail Technology
ABC1 17-Dec-22 123 Pass Java
ABC2 17-Dec-22 135 Pass Java
ABC3 17-Dec-22 156 Fail Java
ABC1 18-Dec-22 123 Fail Java
ABC2 18-Dec-22 135 Pass Java
ABC3 18-Dec-22 156 Pass Java
ABC4 19-Dec-22 166 Fail Testing
ABC5 19-Dec-22 176 Fail Testing
ABC6 19-Dec-22 186 Pass Testing

Table 1: I get only records which are passed in the daily exams.

Table 2: A kind of Code master table.

Expected out put: I would like to get a report which should give all the code records whether passed or failed on daily basis along with the other data from the table 1.

Not sure how to write dax to get Pass or Fail column data for all the codes.

Appreciated your help.

Thanks,

Forum Discussion

DAX Help

Dax

DAX

DAX Behavior

DAX Formula Help

DAX