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.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

The ideal solution in this scenario is create a third Table with a unique list of all Products and create a relationship from ProductName column of Table1 and Table2 to the single column of the third Table (all this can be done in the query editor).  Likewise, from the FiscalYear column in both tables, we should create another column in each table with actual dates.  Then we should build a Calendar Table and create a relationship from the Date columns of Table1 and Table2 to the Date column of the Calendar Table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Ashish_Mathur 

    hi,

    i have created a 3rd table with product name.

    but i dont understand the part on fiscial year.

    My first 2 table has a customlist of all dates, is that similar to the calendar table? 

    how do i go about with it.

    would you advice.  Thank you so much,

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      What is "customlist of all dates"?  That is not a Calendar Table.  Share the link from where i can download your PBI file.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Ashish_Mathur amitchandak 
        hi all
        please see attached

        The value are correct for table Xvalue but not for table Octvalue.
        How can i make them using the same fiscal filter?

        Thank you so much.