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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
hanyfouda2023
Helper I
Helper I

Duplicated values

Hello all ,

I'm working in a sheet must be including duplicates values " We have set numbers of venfing machines from time to time we change its locations but serial number keeps the same only location name changes for example VM#1 yesterday was in location "A" , today same VM#1 will go to location "B".

So my question is how to solve this issue because PBI dont accept any duplicates 

Sample data

Serial # Location Name Operating DateClosing Date
1Daily news01-10-2330-10-23
1Nice life01-11-2330-11-23
1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

Hi @hanyfouda2023 

You need to have a master and transaction tables and create a relationship. Master Table you will have the machines and it will be unique then the transaction table will have the machine IDs with their location trasnfer, from date, to date etc.

Hop this is clear?

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

3 REPLIES 3
Fowmy
Super User
Super User

Hi @hanyfouda2023 

You need to have a master and transaction tables and create a relationship. Master Table you will have the machines and it will be unique then the transaction table will have the machine IDs with their location trasnfer, from date, to date etc.

Hop this is clear?

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Thanks alot it solved the issue

jayppatel07
Frequent Visitor

Hi
what problem are you trying to solve in the report?
can you please explain it with example or if you can share more details that'll be helpful
are you facing issue with establishing relationship with another table ?
from these two rows it seems like only serial# is duplicate not the rows.

Thanks

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors