select if date is greater than the selected slicer date

[Rngomoa]

Hello,

Am trying to define a measure where any date (date_lab_ordered) greater than -12 months of the selected slicer date (CalenderDate[dates]) if a valid date.

my DAX is as follows.

Valid=IF(date_lab_ordered>MAXX(DATEADD(CalenderDate[dates],-12,MONTH),CalenderDate[dates]),"Valid","Not Valid")

However, this labels all cases in the data as valid. Any help is much appreaciated. Thanks

[FreemanZ]

hi @Rngomoa 

how are you going to use this measure, or what context do you have?

if you are plotting the table as it is in the dataset, try to plot with a measure like:

Valid=

IF(  MAX(TableName[date_lab_ordered])>EDATE(SELECTEDVALUE(TableName[date_lab_ordered]), -12),

"Valid","Not Valid"

)