Forum Discussion

XeonBI's avatar
XeonBI
New Member
7 years ago
Solved

Filter 01.01.1900

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!
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, XeonBI 

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

     

    Best Regards,

    Lin

4 Replies

      • v-lili6-msft's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        hi, XeonBI 

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

         

        Best Regards,

        Lin

    • CarlRichards's avatar
      CarlRichards
      New Member
      4 years ago

      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?