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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
mmills2018
Helper IV
Helper IV

Duplicated Data Table not pulling Dates

Hi All,

 

I copied a data table to use as a duplicate, the table i copied is 'consolidated talent snapshot'  I need to connect these reports by field  'job family group' to 'in talent for job family'.  My main data table (not the duplicated one) is connected to a date table, the duplciated data table dates are not working and I am unable to join these two data tables by dates.  any ideas what i can do? below are my models

 

2021-06-09_14-37-06.png

2 REPLIES 2
Anonymous
Not applicable

@mmills2018 

It is a loop error. To make it work, you need to also create a copied date table make it connected to the copied main table. Can you explain what do you want to achieve with the copied main table. 

 

 

Paul Zheng _ Community Support Team

aj1973
Community Champion
Community Champion

Hi @mmills2018 

First of all it is not a good idea to duplicate tables, It consumes space and performance.

Secondly, you sound like you want to join Date table to 2 different Dates column, right? you can still do that but one relationship is going to be active and the other is Inactive. still you can use the inactive one with a DAX formula.

What is that you really want to do?

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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