Power Bi

Hi Anonymous ,

To show the QC time in front of the QC name, you can use a combination of the LOOKUPVALUE function and a JOIN clause in a calculated column in your Analyst table.

Here's an example of how you can do this:

First, add a calculated column to your Analyst table and name it QC Time.
In the formula for the calculated column, use the LOOKUPVALUE function to retrieve the time from the QC table, using the event id and Name columns from the Analyst table as the lookup values. The formula should look something like this:

QC Time = LOOKUPVALUE(QC[Time], QC[event id], Analyst[event id], QC[Name], Analyst[Name])

Next, you can use the JOIN function to join the Analyst table to the QC table, using the event id column as the join key. The formula should look something like this:

JOIN(Analyst, QC, "event id", "event id")

You can then use the QC Time column in your table visual to show the QC time in front of the QC name.
Note that the JOIN function will only work if there is a one-to-one relationship between the Analyst table and the QC table, meaning that each event id in the Analyst table corresponds to exactly one event id in the QC table. If this is not the case, you may need to use a different approach, such as using a LEFT JOIN or a RIGHT JOIN to handle cases where there are missing values in one of the tables.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.