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!
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?
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 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 😃