Forum Discussion
Combing graphs from 2 datasets on the same tab
Not sure if this will help. So I have 3 data sets on one page. I have two them working, the third one it will not let me create another many to many relationship. So my Jobs and Utilization tables are working and joined to the calendar table and the company and yard table. This enable both to filter correctly. My budget and revenue table it will not let me join to the company, yard or calendar table. As you can see I have added another calendar table but it is only letting me make one join there. Does this help?
Community ChampionAnonymous
Anonymous
BTW, looking at the screenshot of your model, I think you are confused about how relationships, lookup tables, and filter conexts work. Just as an example, it is VERY rare to have more than one relationship between two tables (generally you only need more than one relationship between two tables if for example your fact table has two date fields - for example, purchase date and delivery date).
And it seems you have two or three stemming from one table to another in a few tables.
So I cleaned everything up and now it is letting me make the joins and everything is working as it should on my combined tab. Which is great. I have one last issue that is not working as expected. I have my Invoice Created date and I have linked that in a many to one relationship with the date field in my calendar table. It is active. I have made the Year and Month columns has my slicers on my tab, but whenever I select them all of my data goes blank. I went and reformatted the date so that it was no longer date time just the date, I have removed the link and added it back but nothing is working. I really am at a loss.
- vivran22Is it possible to share the sample data from both the tables along with the DAX you've created?
VivekSo here is the dax I am using for my Calucations for current and prior year.
Avg End Work to Export Date = CALCULATE( AVERAGE('Days to Invoice US All'[End Work to Exported Invoice]))Avg End Work to Export Date PY = CALCULATE([Avg End Work to Export Date],SAMEPERIODLASTYEAR('Calendar'[Date]))Below are screen shots of my data table, showing the Inv Created Date that I am using, How they are joined, and what the calendar table looks like. Is that what you were wanting? I have Current year and prior year calcuations on 3 or 4 other tabs and they are all working off of just the many to one join with the calendar table. But all of those are being run off of the job start date. But the date I am using should not matter right? I mean joining a date to date is the same regardless of what the date is named, right?
