Forum Discussion
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 Date | Closing Date |
| 1 | Daily news | 01-10-23 | 30-10-23 |
| 1 | Nice life | 01-11-23 | 30-11-23 |
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?
3 Replies
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?Thanks alot it solved the issue
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
