Forum Discussion
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 Category Value Renewing 150 Repairing 100 T...
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.
Thanks a lot for your help. I would definitely give a shot to your solution.