Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

vivran22's avatar
vivran22
Icon for Community Champion rankCommunity Champion
6 years ago
Is it possible to share the sample data from both the tables along with the DAX you've created?

Vivek
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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?
     
     
  • vivran22's avatar
    vivran22
    Icon for Community Champion rankCommunity Champion
    6 years ago
    Thank 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.
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.