Forum Discussion
link columns
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
| Company | Accountable date | Supplier | Kind of cost | cost in $ | Month | Year | Country |
But my amount of cheese, bun, steaks used is in another table....
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).
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.