Cannot use date column in measure

[Thimios]

Hey all,

I have a very simple model, Date table & Data table. Data table has a Date type column. I need to create a measure calculating DATESDIFF or even DATESBETWEEN my date column and TODAY(). 

When writing the measure though, my date column is not available to use (actually only measures are available, not columns). Am I not getting something here as far as setup is concerned?

[Payeras_BI · Accepted solution]

Hi @Thimios ,

The function expects a scalar value. 

Try by wrapping your date column with SELECTEDVALUE(), for instance.

[manikumar34]

@Thimios , 

Take MAX or MIN o the date.

datediff = DATEDIFF(MAX(Sheet1[Date]),TODAY(),DAY)

Regards, 

Manikumar

[PhilipTreacy · Accepted solution]

Hi @Thimios 

A measure using SELECTEDVALUE() as @Payeras_BI suggests will work.

Measure = DATEDIFF(SELECTEDVALUE('Table'[Date]),TODAY(),DAY)

Regards

Phil

[PC2790]

Hi @Thimios,

Try creating a calculated column using the below DAX formula:

Column = CALCULATE(COUNTROWS(DateTable),DATESBETWEEN(DateTable[Date],DateTable[Date],TODAY()))

[Payeras_BI · Accepted solution]

Hi @Thimios ,

The function expects a scalar value. 

Try by wrapping your date column with SELECTEDVALUE(), for instance.