Forum Discussion

Thomas897's avatar
Thomas897
Helper I
9 years ago
Solved

link columns

Hello everyone,   I have an issue. I explain myself with an example. Ex: I sell burgers for the same price but some client do not want pickles for example. Let's say that I sold 100 burgers for j...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Thomas897

     

    Is that how your current data is stored? What can you tell me about the related table? What does the desired result look like?

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thomas897

 

Is there a way to connect the tables?

Thomas897's avatar
Thomas897
Helper I
9 years ago

Anonymous

 

Yes, it works but some of the numbers are not right because for example, for my 100 burgers of july, we used cheese that was in stock for june and we did not need to buy more so Power BI understands that we did not need cheese at all in july... I mean it is really hard to explain and I cannot really show you (I do not think my boss would appreciate it).

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Thomas897

     

    I understand. I really want to help, but I kind of need to see how the data is stored, so my advice would be to create a table with false data and then give it to me so I can see if it is even possible, and then if it is, how we can go about solving it. It's going to be really hard for me without. Dummy data is fine, I just need to see the table structure if that makes sense.

    • Thomas897's avatar
      Thomas897
      Helper I
      9 years ago

      Anonymous

       

      Well, I will comeback to you later because I do not have all the data right now...

      Thank you for your time !

      • Thomas897's avatar
        Thomas897
        Helper I
        9 years ago

        Hi Anonymous,

         

        MonthYearCompanyCountryBurgers soldBunsSteaksCheesePickle
        12016XFRA59205920592053284144
        22016XFRA63436343634357094440
        32016XFRA24392439243921951707
        42016XFRA65346534653458814574
        52016XFRA77627762776269865433
        62016XFRA23462346234621111642

         

        So basically, I want to show that for 5920 burgers sold in 01/2016, 5236 and 4144 cheese have been used.

        The thing is that I have a pie chart (link between 2 tables) with my suppliers and, as we do not receive bill from them every month, Power BI believes that any cheese or pickles have been used. So I'd like to know if it is possible.

         

        Thanks :)