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.

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.

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

      Hi,

      Does the FY run from December to November?  Also, the best would be to append data from both datasets into a single one and then build your Pivot Table.  Would you be amenable to this approach?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Ashish_Mathur 

        in this case, the fy is from april to march.

        is there any way to use the current pbix file to make it work or add calendar?

        I won't be able to make changes to dataset.