Help to create a inventory projection report

hello CampBI 

What I can understand, your lines are breaking as you dont have consistent data in every week for reserve, SO and arrival and the graph representing correctly. connecting those lines will give a wrong representation. Rather I will suggest to use Matrix visual to represent this. Also in case of line graph, You may customize the chart like... connected line for forcasd and keep only dots for other categories. 
If I missunderstood your ask, let me know some mote details of the concern

thanks

Hi CampBI ,

Based on the sample data, the graph is looking like below. Let me know wheter I am in right track or you need something else

 Hi CampBI ,

the process is same as I explained in the previous thread. 

1. I have considered 4 source tables for Inventory, Productio, PO and SO. All these tables three columns name kept common. date, colour and item. values of these tables may have relevant column names.

2. Created a union table:

Union table = 
ADDCOLUMNS(
    DISTINCT(
        union(
            DISTINCT(SELECTCOLUMNS(inventory,inventory[Date],inventory[Item],inventory[Color])),
            DISTINCT(SELECTCOLUMNS(PO,PO[Date],PO[Item],PO[Color])),
            DISTINCT(SELECTCOLUMNS(Production,Production[Date],Production[Item],Production[Color])),
            DISTINCT(SELECTCOLUMNS(SO,SO[Date],SO[Item],SO[Color]))
        )
    )
    
    ,
    "Inventory",LOOKUPVALUE(inventory[Inventory],inventory[Date],inventory[Date],inventory[Color],inventory[Color],inventory[Item],inventory[Item]),
    "PO",LOOKUPVALUE(PO[Arrival],PO[Date],inventory[Date],PO[Color],inventory[Color],PO[Item],inventory[Item]),
    "SO",LOOKUPVALUE(SO[Sale Order],SO[Date],inventory[Date],SO[Item],inventory[Item],SO[Color],inventory[Color]),
    "Prod",LOOKUPVALUE(Production[Production],Production[Date],inventory[Date],Production[Color],inventory[Color],Production[Item],inventory[Item])
    
)

3. Created a calculated column in the union table

Stock = 'Union table'[Inventory]+'Union table'[PO]-'Union table'[Prod]-'Union table'[SO]

4. Created a calender table and made relationship with all 4 source tables on date.. (note: dont make any relationship with the union table)

5. Created a measure

Stock forecast = 
CALCULATE(sum('Union table'[Stock]),ALLEXCEPT('Union table','Union table'[inventory_Item],'Union table'[inventory_Color]),'Union table'[inventory_Date]<=max('Calendar'[Date]))

6. now take a line & clustered bar chart combo visual. put date from the calender table in x-axis. put Stock forcast measure in the secondary axis. this will display the forcast.

7. Now to create different bars for PO, SO ,Inventory and Production, create four different measure as below and put them in the primary Y-axis.

Inventory_value = CALCULATE(sum('Union table'[Inventory]),'Union table'[inventory_Date]=max('Calendar'[Date]))

SO_value = CALCULATE(sum('Union table'[SO]),'Union table'[inventory_Date]=max('Calendar'[Date]))

Prod_Reserve_value = CALCULATE(sum('Union table'[Prod]),'Union table'[inventory_Date]=max('Calendar'[Date]))

Arrival_value = CALCULATE(sum('Union table'[PO]),'Union table'[inventory_Date]=max('Calendar'[Date]))

 8. Slicers will be from union table.

thats it. cheers....

some of your date column is formatted as text. change it to date.

Hi Mathewtmp ,

Please share sample table here as plain text.

Hi Rupak,

Thanks for replying. I am  assuming you meant the tables in the database?

If so please see below the the same as text.

Table SOH

Table SIT

Table Demand

Table Part