Forum Discussion

ArtieLadie's avatar
ArtieLadie
Regular Visitor
7 years ago

Remove Duplicates in Created Table

I use PowerBI to select THREE tables from a remote Oracle SQL Database

 

 

 

 

And I use the Table Visualization to create a Table (some data blocked for privacy)

 

 

But I want to Remove Duplicate columns from Year, Quarter, Month, Day, DOMAINUSERNAME, MESSAGESUBJECT.

 

How to do this?

Need Help
Show and Tell

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I think you should be able to do that in Power Query, at least you can when importing from SQL server

  • mussaenda's avatar
    mussaenda
    Community Champion
    7 years ago

    What is your expected result?

    You may use a Matrix Visual to remove repetitive values from dates.