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?

     

     

Thomas897's avatar
Thomas897
Helper I
9 years ago

Hi Anonymous,

 

I would like to show that when I click on my supplier (ex: Kraft for my cheese), how much of their product is used on my 100 burgers.

I have all these informations but I cannot find a way to connect it...

 

Best,

Thomas

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thomas897

 

Can you show me a sample of how your data is stored?

  • Thomas897's avatar
    Thomas897
    Helper I
    9 years ago

    Anonymous

     

    Company  Accountable dateSupplierKind of cost cost in $MonthYearCountry 

     

    But my amount of cheese, bun, steaks used is in another table....

    • 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).