topic Re: Now to compare two date columns from different tables in DAX Commands and Tips

Now to compare two date columns from different tables

Anonymous — Fri, 23 Dec 2022 08:56:51 GMT

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.

Re: Now to compare two date columns from different tables

Mahesh0016 — Fri, 23 Dec 2022 10:55:16 GMT

Anonymous

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

Re: Now to compare two date columns from different tables

v-jianboli-msft — Mon, 02 Jan 2023 07:59:18 GMT

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.