Forum Discussion
Adding a key to a table
Hi RenaG ,
First, in power bi, table visual hides the exact same rows. So I'm guessing that the duplicates you describe could mean something else, such as the duplicate RunDate shown below, which needs to show the latest RunDate:
Please feel free to correct me and provide more information if I have misunderstood you!
An attachment for your reference. Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your quick reply. Here is some more info that may be helpful.
Each week I run a report that pulls records YTD. So a patient who appeared last weeks' results most likely will appear in this weeks' results. I checked the result file and there are no duplicates within that result. But when I appended this week to the Master (which contains last weeks' data) and did an Apply and Close then I got the error that there were duplicates. I thought the tables had been created with a key of Pat_ID and RunDate (another person created the framework of this dashboard but has since then left the company). Now I am tasked with getting it to work going forward. All of the Master tables will be updated this way each week so I am sure to run into this on all of them. Is there someplace I can go in the Applied Steps and indicate that the keys need to be on Pat_ID and RunDate? I looked at the Model View and can't tell that the Pat_ID is the key on this particular table so I don't know where or how that is set.
I hope this all makes sense.
Any thoughts?