Forum Discussion
Adding a key to a table
RenaG Potentially. You could probably create a function or otherwise extract the file creation date or what not and include that as a column in your tables. You could then create a unique key from that and your pat_ID field. Specifics are going to vary. Are you using a Folder query?
Greg_Deckler Thank you for your reply. I am a novice PowerBI developer so I don't understand your solution. Are you suggesting that in the Applied Steps on each table, somewhere at the beginning I create a column that contains the data from the pat_id and the run date? If so, how do I set that as the key for the table?
Greg_Deckler I was wondering if you had any other thoughts on this question. I can create a composite column with the pat_id and run date. I don't know how to indicate that field is the unique key. Can you explain that process? Thanks!
