Two different data sources in one visual

[Chainfire74]

Hi, I've created a line chart which will have starters and leavers, there are two different tables (one for each).

Both tables have the relevant dates, however when I want to break the results down by quarters it is only updating one of the table numbers while the other numbers stay the same throughout the whole quarters. Could anyone help with this please?

[SpartaBI]

@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.

      

Showcase Report – Contoso By SpartaBI

[Chainfire74]

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?

[SpartaBI]

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

[Chainfire74]

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.

[SpartaBI]

@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? 

[Chainfire74 · Accepted solution]

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!

[SpartaBI]

@Chainfire74 great! You see, it was easy after all 🙂 when you have a proper model, in this case, you added a dim dates, everything including DAX is much simpler 😃