Fields not appear in new measure

[Arenna]

Help..

I have column named "Driver_Card_Expiry_Date". I tried to use New Measure.

     Months Left = DATEDIFF ([Today Date], ________________, MONTH)

The column I want won't appear. Please help tp solve. I've been at it for half a day.

Thanks.

[SivaMani · Accepted solution]

@Arenna,

You can't use the column as a reference in measure since measure expects and returns a single value.

Use LASTDATE() DAX function. it will take last non-blank date and calculate month difference.

E.g,

 Months Left = DATEDIFF ([Today Date], LASTDATE(Driver_Card_Expiry_Date), MONTH)

[SivaMani · Accepted solution]

@Arenna,

You can't use the column as a reference in measure since measure expects and returns a single value.

Use LASTDATE() DAX function. it will take last non-blank date and calculate month difference.

E.g,

 Months Left = DATEDIFF ([Today Date], LASTDATE(Driver_Card_Expiry_Date), MONTH)

[Arenna · Accepted solution]

Thanks Siva,

It took me my whole morning to learn about that. I just found the 5 golden rules for DAX Measures, and no.2 is No Naked Column.

I understood that and use the Calculated Columns instead. And voilaa..!  It works.

MONTHS LEFT = DATEDIFF(TODAY(), DRIVER[Date Expire].[Date], MONTH)

Thanks for your input Siva !