Forum Discussion
How to related tables with multiple fields in common?
Community ChampionHello udedomenico
you were stating about removing fields in your post, and I asked whats that does mean 🙂
But in your scenario, why you are not connecting the the sales and budget table to the customer.customer number field? This should work be fine.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
Hello Jimmy801 ,
the reason why I need to connect sales and budget tables is because I would like to explore which customers had a budget and ended up buying or viceversa, they bought something but they never had budget.
I hope that explains.
Thanks,
Umberto
- Jimmy801
Hello udedomenico
but they are connected through the customer table. I don't see the reason to connect them in another way.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
JimmyHello Jimmy801 ,
Thank you for your help! you are inspiring 🙂
You are right the customer table is enough to connect the sales and budget table.
But then in the design layer you will need two calendar slicers, one for the sales table and the other one for the budget table.
Of course we can go for this solution but broadly speaking that create usability issues and it is always recommended to have one calendar only, unless specific reasons request a different solution.
Thanks,
Umberto
- Jimmy801
Hello udedomenico
Thank you 🙂
when you want to connect them also with year and month you have to do the following
- you have a dates column also in your dataset, or only month and year? If you have dates you can create a new calendartable with a DAX-function. If you have only month and year create in both tables a new column, were you are putting them together the same way. Then you can union both new columns into a new table.
- as soon you have a new table with your date-data, connect sales and budget to this new table. Hide dates-colummn in the original dataset
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy