Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

need help in editing relationship

dear all, i have 2 data source, named 1) datasheet1 2) datasheet2 both sources has the column "productname", which i linked them in relationship. I have another calculated column in both sources...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    Download my PBI file from here.

    Hope this helps.

venal's avatar
venal
Icon for Memorable Member rankMemorable Member
6 years ago

Anonymous 

Create a new column by concatenating the "ProductName" and "FiscialYear" in the 2 tables. (Ex:- Column-ID)

Remove existing relationships and create a new one by using the ID column.

 

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

If this post was helpful may I ask you to mark it as solution and give it some kudos?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

venal 

hi, it doesnt allow me to use concatenate? both fields are text field (though the fiscalyear is a calculated column).

Any advice?

Thank you.