I have two tables, Sales and Budget that are related by CustID.
When I try to add a visual that shows Sales vs Budget per month, the total Sales shows correctly, but I get the sum of all budgets for the Budget value...
Is there any way that I can have the Budget show correctly for each month?
Go to Solution.
@JamesOncam You need to have a Customer table and Date table, which can be linked to Sales and Budget tables in the first place.
Did I answer your question? Mark this post as a solution, this will help others!.
I accept KUDOS 🙂
View solution in original post
@Fowmy that worked perfectly, thank you
I assume this is what you meant:
@JamesOncam , Create a customer Table
You can also try like
Customer = distinct (Union(all(Sales[CustID]),Budget[CustID])))
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.