Add manual data to existing data from Direct Query

dshah12 · ‎10-05-2023

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 · ‎10-05-2023

@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.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.