Forum Discussion

cocoloco79's avatar
cocoloco79
Icon for Helper III rankHelper 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 ...
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!

MattiaFratello's avatar
MattiaFratello
Icon for Super User rankSuper 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
    Icon for Helper III rankHelper 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
      Icon for Super User rankSuper 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?