Now to compare two date columns from different tables

[Anonymous]

I need to compare two date columns in the tables 'Verzuim' and 'Verzuimmelding', both are conected to a central date table.

Verzuimmelding column show the start date of when somebody called in sick.
Verzuim column shows the total days of them being sick (as an example if somebody called in sick on 01-01-2022 and returned on 08-01-2022, then it would show 01-01, 02-01, 03-01 etc etc).

I need to check if the start date is the same as the date that they called in sick, but I just can't seem to find the right forumla.

[v-jianboli-msft · Accepted solution]

Hi @Anonymous ,

Please try:

the date that called in sick = CALCULATE(MIN('Verzuim'[Date]),FILTER(ALL('Verzuim'),[ID]=MAX('Verzuimmelding'[ID])))

Then apply it to the visual:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mahesh0016]

@Anonymous 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.