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,

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.

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

    Hi,

    I doubt I'll be able to help in that case.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Ashish_Mathur 

      if it got to make the changes in dataset, how should it look like...

      It would definitely help in the future.

       

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

        Hi,

        I don't think any changes in the dataset are required.  In order to try to help you, I may need your PBI and your source Excel files from where you imported data into PBI.