Forum Discussion
Lookup column from Direct Query that includes duplicates
Hi all, I need some help please - any help is greatly appreciated. I have a table called Tickets that includes Project ID as a column. I also have a second table called ProjectPortfolio that i...
Therefore, I need to clean this data in PBI before merging it with Table Tickets.What's your rationale for trying to merge these tables? Is that something you may rather want to do in the data model?