Forum Discussion

cocoloco79's avatar
cocoloco79
Helper III
1 year ago
Solved

Working with two datasets

Hi everyone,

 

I'm stuck working with two datasets, trying to calcuate values in the same table.

 

I crated two uion tables and and connect them wioth a one to many relationship.

I also created a Date table and calcuated a Weekstart Start date, which I connected with those two datasets.

Sold Kg are doubeling up even though there should only be one value for Week start date 07/04 for is_organic "False".

 

I'm not sure how I can work two datasets into one table. 

 

Any help is much appreciated.

 

Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    Hi cocoloco79,

     

    Hi ,
    we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

    If our response addressed by the community member for  your query, please mark it as Accept Answer and give us Kudos. Should you have any further questions, feel free to reach out.


    Thank you for being a part of the Microsoft Fabric Community Forum!

11 Replies

  • MattiaFratello's avatar
    MattiaFratello
    Super User
    1 year ago

    Hi cocoloco79, what are you using for your relationship? Date or WeekStartDate? And what do you have in your fact table?

     

    Also, why the other relationships are inactive? The dotted ones

    • cocoloco79's avatar
      cocoloco79
      Helper III
      1 year ago

      Hi MattiaFratello ,

      Releationship is between WeekStartDate, the other tables are not part of what I'm tring to do.

      bi_budget table holds budgeted kilos by week, crop and crop type.
      bi_dashboard table holds all the sales data, which I'm trying to match by crop, crop type and week start date.

       

      Any suggestion on how to aproach this? creating a combined table perhaps? I'm not sure

      • MattiaFratello's avatar
        MattiaFratello
        Super User
        1 year ago

        Why your relationship btw bi_dashboard and bi_date is many to many? Can you show me this relationship? Can you open it for me and make a screenshot?