The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
@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
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
User | Count |
---|---|
62 | |
57 | |
54 | |
51 | |
33 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
43 |