Forum Discussion
Relationship between two tables
if both columns (Date and Name), together are unique, you can create a calculated column (DAX or in power query , which i prefer) ,to concatenate the 2 columns in one column .
DAX : cc = concatenate( tbl_name[col_name], tbl_name[col1_name])
then you link both tables on this new column .
let me know if this works, or your requirement is something else .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
if both columns (Date and Name), together are unique, you can create a calculated column (DAX or in power query , which i prefer) ,to concatenate the 2 columns in one column .
DAX : cc = concatenate( tbl_name[col_name], tbl_name[col1_name])
then you link both tables on this new column .
let me know if this works, or your requirement is something else .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
Thank you, I appreciate that.
