Forum Discussion
add column to table (from another table)
Hello Community - Below is my budget table.
I am trying to add in the "actual" sales, by month, as another column in my budget table. It seems that KPI visuals want you to have the actual and the target value in the same table to use them properly.
My budget table is at month granularity. My shipment revenue (fact table) is at daily granularity. And I have a date table (connected to ship date on the shipments table, and to "date" on my budget table.
I am trying to bring in the actual MTD sum of each month (from the shipments table) as a new column in my budget table. I tried this below but not working. Any suggestions?
Anonymous I don't think you need to bring sales in the budget table, just add two measure, one is the sum of sales and one is the sum of budget and on KPI visual, use sales measures on the indicator, month column from date table on target axis, and put the budget measure on target goal section and it should work.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
3 Replies
- parry2k
Super User
Anonymous I don't think you need to bring sales in the budget table, just add two measure, one is the sum of sales and one is the sum of budget and on KPI visual, use sales measures on the indicator, month column from date table on target axis, and put the budget measure on target goal section and it should work.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Thanks parry2k Got it to work thanks to your help. Also, I visited your scenario mentioned above as it also fits something I am working on. But in your example, it does seem like you have "actual" and "budget" values in the same table?
- parry2k
Anonymous not it doesn't matter if they are in the same table or not, I'm not fully sure about your comments but seems like it is working for you.