Filter 01.01.1900

[XeonBI]

Hello,

I have got a date table having 01.01.1900. How can I filter it? The following formula is not working:

CALCULATE(Min ('Date'[Date]; FILTER('Date'; 'Date'[Date] > 0)))

Thank you!

[v-lili6-msft]

hi, @XeonBI 

There are two ways for you to refer to:

1. in the formula, try this conditional

CALCULATE(Min ('Date'[Date]), FILTER('Date', 'Date'[Date]<>DATE(1900,1,1)))

https://docs.microsoft.com/en-us/dax/date-function-dax

2. In visual/Page/Report level filter to filter 01.01.1900 value

https://docs.microsoft.com/en-us/power-bi/power-bi-report-add-filter

Best Regards,

Lin

[CarlRichards]

Hi, Sorry, this resolution tells people how to filter out the records with 01/01/1900 but my client wants to filter on these records, When we select them to be filtered you end up with an error (The visual has unsupported dates). How do you work with this issue?

[XeonBI]

Thank you so much!!!

[v-lili6-msft · Accepted solution]

hi, @XeonBI 

you are welcome,  Could you please tell me if you have other problems? If not, could you please mark the helpful replies as Answered?

Best Regards,

Lin