Forum Discussion

dshah12's avatar
dshah12
Helper II
2 years ago

Add manual data to existing data from Direct Query

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 

CategoryValue
Renewing150 
Repairing100

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 

CategoryValueForecast 
Renewing150 1000
Repairing1002000
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    2 years ago

    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's avatar
      dshah12
      Helper II
      2 years ago

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