Forum Discussion
Two different data sources in one visual
Unfortunately, where I work won't allow it. Thank you so much for offering to help though.
I have found a solution:
Starters = CALCULATE(distinctCOUNT(Starters4[Employee Number]))This worked and I've managed to get the table looking how I wanted it.Thanks again!
Chainfire74 do you have a date table that is connected to both?
Check that you used the month from the date table on the X axis and not the month from only one of the tables.
I didn't, but I do now thank you. Now I need to sum the amount of times a certain date appears and add it to the graph. Do you know how I would do that please?
I do but I need more info about your scenario 🙂 You can PM to do a zoom or share here your file and I'll take a look
I would but it's sensitive date so I'm unable to. If it helps, I have a list of starters and leavers in two different tables. The starters have their start dates and the leavers have the date they left. I'm trying to show a line graph for both. I have the date table and have broken it down by quarters.
When I add the start/leave date at the minute, this is what I get because it isn't summing the dates.
Please let me know if you need any more info, really appreciate your help.
Chainfire74 I guess it's really easy but I really need to look at that with you?
Can't you do a zoom / teams / google meet?