How to write a date Expression

[kelly_oakley]

Morning all,

I am working with some data that has dates attached unfortunately for 1 reason or another there are many that contain 01/01/1900 and I want to omit those from the data as this is just rubbish.

Is there a quick expression that I can put in ?

thanks

[C_Howarth]

I believe what you are after for this is something along the lines of:

=sum({<[date] ={">01/01/1900"}>}[value])

the important part her is the [date]={">01/01/1900"}  which is telling the measure to only bring back values where the date is greater than 01/01/1900

[kelly_oakley]

Hi, thanks for the reply, sorry I didn't explain myself very well.

I am building a table with columns in and its the date column where I want to remove the 1900's

I feel I need to do an if statement but not sure how it would be written