Budget Control Report - Multiple variants

Question

Hello, its me once again.&nbsp;I am trying to figure out the best way to give the following report. I have a database "A" in which holds the budget of my product with 3 columns. First column is the item name, second column would be the additional feature of the item (lets name it color for practical purposes) and the 3rd column would be the number of items to be delivered. Then, there´s database "B" which holds all the items that are being delivered within this year. Database "B" has more columns than "A", however they share the same amount items and the same 4 color variety. So what I am trying to do here is a report that shows the following:Current Budget from Database A, Current deliveries for DataBase B, and I would like to have measures to substract the difference. This difference would be known as a column as "Pending delivery". I also have database "C" with the current inventory of the items with their "colors" as well. So I am trying to answer the following questions.What is my current budget on x item, and y zone,How much items do I need to deliver to reach my budget.How much inventory would there be available after such deliveries, with all the variants.And basically setting this kind of matrix.ZONE - &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;ITEM - VARIANT - BUDGET - DELIVERIES - PENDING - CURRENT INVENTORY - SURPLUS/SHORTAGECOUNTY 1 &nbsp;- Pencil - &nbsp; &nbsp;Blue - &nbsp; &nbsp; &nbsp; 3000. &nbsp; &nbsp; &nbsp; 1000. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2000. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2,500 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;+ &nbsp;500COUNTY 2 &nbsp;-&nbsp;Pencil - &nbsp; &nbsp;Red. - &nbsp; &nbsp; &nbsp; &nbsp; 2,500. &nbsp; &nbsp; &nbsp;1500. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1,000. &nbsp; &nbsp; &nbsp; &nbsp; - &nbsp;300. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; - 700COUNTY 3 - Pencil - Blue. &nbsp;- &nbsp; &nbsp; &nbsp;2,000. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1200. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 800. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;800. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp;Notice that every county would have their own independent budget regarding item and variant.Any help would be greatly appreciated. Should you require more information or a dummy excel sheet let me know. Thank you for your time.&nbsp;&nbsp;

anonymous · Answer

Hi Shackwell,
According to your description, it seems like you told the requirements but do not share enough information. 
Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly&nbsp;&nbsp;
Regards,
Xiaoxin Sheng

shackwell · Answer

Let me prepare the data and I will share with such variables. Thanks.

anonymous · Answer

HI&nbsp;Shackwell,
Any updates for these? If you are still confused about these, you can feel free to post here. If you already found the workaround or solution, It will be appreciated to share them to help other users who faced similar scenarios.Regards,Xiaoxin Sheng

Forum Discussion

Related content

Version control

Power BI Chart for Multiple X axis variants

Multiple Variant Type

Version Control / Quality Control Best Practices

control multiple bookmarks with 1 button