Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Dhruv-123
New Member

Power Bi

  • Hi ,

I am new to Power BI.. I have one issue

 

two tables,

analyst table:

event id.  Name. Time. Date

1865.       Lopez. 5.63. 22/07/2022

1867.        Stanf.  1.63.  14/08/2022

 

QC table:

event id.   Name.   Time.  Date

1865.        Lopez1.    6.00. 24/07/2022

1867          Stanf.        3.00  14/08/2022

 

here I am using name from Analyst table in my table visual in power bi desktop and date as a slicer from analyst table as well

 

now I am looking to show qc time infront of the qc name

Ex: if I do lookupvalue it is showing infront of analyst name

 

here with lookupvale

for event Id: 1865 ,time 6.00 is showing infront of Lopez but it need to show infront of Lopez1

 

and user able filter the data based on date as well.

Any suggestions please

Thanks in advance

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

Hi @Dhruv-123 ,

 

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.

View solution in original post

3 REPLIES 3
v-henryk-mstf
Community Support
Community Support

Hi @Dhruv-123 ,

 

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.

Ashish_Mathur
Super User
Super User

Hi,

Your requirement is not at all clear.  in the first place, you should create Dim tables for all 4 fields.  Next, add another field in each Fact table with the title of Type and have Analyst or QC in each row.  Append the two tables.  Create a relationship (Many to One and Single) between the 4 fields of the appended table and the 4 dim tables.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.