Forum Discussion
Grouping data from two tables by Date
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?
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 🙂
3 Replies
- Fowmy
Super User
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 🙂
- amitchandak
JamesOncam , Create a customer Table
https://www.seerinteractive.com/blog/join-many-many-power-bi/
You can also try like
Customer = distinct (Union(all(Sales[CustID]),Budget[CustID])))
