I have 2 referenced tables that get loaded into my model. Table1 contains unpivot data with a Date column, and Table2 contain the raw data with no dates (date are concatenated in horizontal columns). Both tables have a relation via the index column.
From PQ, I was trying to add the date column to table2, but when I try to merger table2 with table1, I keep getting the error of using the relationship due to duplicate index ids.
So I thought Dax could solve the problem. Any input is much appreciated.
Hi @Hesham, did the response provided by @adam help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!
Hi @Hesham, we’ve noticed that no response has been received from you since the 24th of February. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved.
Hi @Hesham, did the response provided by @IlgarZarbaliyev help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark as solution the answer that solved your query. Thanks!
Hi @Hesham, a response on this post has been tagged as “Solution”. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the check box.
We’ve recently launched the Enterprise DNA Forum User Experience Survey, please feel free to answer it and give your insights on how we can further improve the Support forum. Thanks!
