DATEDIFF measure does not show date colum

[ArtRijnvicus]

Hello all,

I want to calculate the week differences between a datecolum (deelnemers[AanvangStatus] and todays date. I want to do this by a Measure.

The DAX formula im using is: DATEDIFF(...

the date i want to use in Date1 = deelnemers[AanvangStatus], but as you can see (in printscreens below), its only allowing me to use measured values from table deelnemers (which are no date colums?!).

How can I use deelnemers[AanvangStatus] colum in the DATEDIFF measure? (or what am i doing wrong?)

Greetings,

Art

[JorgePinho · Accepted solution]

You have tu use a summarization function  such as MAX.

Try this:

Diff = DATEDIFF(MAX(Date1), TODAY(), WEEK)