Forum Discussion
Combing graphs from 2 datasets on the same tab
So I am sure what I am trying to do has been done before. I am half way there and feel like I am just missing a small piece. I am graphing revenue and hours on the same tab but the data is coming fro...
vivran22
Community Champion
Community ChampionIs it possible to share the sample data from both the tables along with the DAX you've created?
Vivek
Vivek
So 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?
- vivran22Thank you for sharing the details.
I have a question regarding the date range available in the Days to Invoice US all table: What is the date range available in this? From the screenshot of the visual you shared earlier, it seems that when you are deselcting 2019, you are not getting any data. So that result is when I have the Year and Month filters from the Calendar table as my slicers. I have it that way on my other tabs so that my prior year calucation will work. However, using them on this tab only seems to result in no data at all even with the tables being joined. This is what the data looks like when I use the actual inv created date from the days to invoice all table.