Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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