Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Kasiop
Helper II
Helper II

Fake duplicate in Table (link between 3 tables)

Hello,

 

I am struggling with my table and with what I call "fake duplicates". I have 3 tables that feed my pbi table (report) but I have seen multiple line where I am supposed to have only one. 

below the 3 table with Data Product as a key, only Definition tables as unique data product, we have duplicates on the two others:

Kasiop_0-1733234341255.png

 

Table in report:

I have multiple data product lines displayed with little difference on value for some fields.

 

So I would like to have, for one data product groupe, only one line per data product.  

 

If you have some ideas, I willing to try them.

 

Thanks

1 ACCEPTED SOLUTION
Jai-Rathinavel
Super User
Super User

@Kasiop You can create a calculated column to filter only latest records. Use the belox DAX and apply "Yes" to the filter. This will filter only the latest record for each product name.

Is Latest ? = 
var a = CALCULATE( MAX('Definition'[Last Change Date]), ALLEXCEPT('Sample','Sample'[Data Product Name]))
RETURN
IF('Definition'[Last Change Date] = a , "Yes", "No")

 

Did I answer your question ? Please mark my post as a solution.

 

Thanks,

Jai

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

3 REPLIES 3
v-yohua-msft
Community Support
Community Support

Hi, @Kasiop 

You can remove duplicates in a table in Power Query Editor before you load the data into Power BI. Select the column that defines a unique row and use the Remove Duplicates feature.

vyohuamsft_0-1733797982284.png

 

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Kasiop
Helper II
Helper II

Thanks @Jai-Rathinavel but I cannot use your solution, I dont have a date to filter and I think my duplicates came from the links between tables... but I dont know what is the issue

Jai-Rathinavel
Super User
Super User

@Kasiop You can create a calculated column to filter only latest records. Use the belox DAX and apply "Yes" to the filter. This will filter only the latest record for each product name.

Is Latest ? = 
var a = CALCULATE( MAX('Definition'[Last Change Date]), ALLEXCEPT('Sample','Sample'[Data Product Name]))
RETURN
IF('Definition'[Last Change Date] = a , "Yes", "No")

 

Did I answer your question ? Please mark my post as a solution.

 

Thanks,

Jai

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.