Date in the past or future

[Sam-L]

Hello,

I'm looking to create a new column in a table that states 'valid' or 'invalid' based on if a date field is in the past (invalid) or future (valid).

I'm struggling with how to do this. My column is in short date format (dd/mm/yyyy). My date field is in a table named Courses and the field name is employee_training_courses.expires_on.

I've tried myself to workout a DAX query or a new column but can't work it out.

Thanks in advance for your tips.

Sam

[Anonymous]

Try this:

Valid = IF(

Data[Date]>=TODAY(),

"Valid",

Use your date column at the place of Data[Date]

"Non Valid")

Let me know

GV

[amitchandak · Accepted solution]

@Sam-L ,

a new column

Switch( True(),

[Date] < today(), "Invalid",

[Date] > today(), "Valid",

"Today"

)

Change as per need