Add manual data to existing data from Direct Query

[dshah12]

I have one table where it takes data using direct query but I want to add the forecasted amount side wise which is a manual. For example 

Category	Value
Renewing	150
Repairing	100

This kind of table I get from direct query 

But I want a column added to it called Forecast which is manual.

I tried merge queries and append but is not supported with Power BI direct query. I created many-one realationship but then I am having trouble creating difference  of Value - Forecast 

Help appreciated 

Thank you 

Category	Value	Forecast
Renewing	150	1000
Repairing	100	2000

[parry2k]

@dshah12 you need to keep your forecast table separate and then add another dimension table for categories that will have a relationship with both the forecast and the dq table.

With this you will able to do any sort of calculations by using the category column from the category table. 

[dshah12]

Thanks a lot for your help. I would definitely give a shot to your solution.