Forum Discussion

christianfcbmx's avatar
christianfcbmx
Icon for Post Patron rankPost Patron
8 years ago
Solved

Date column "NOT RECOGNIZED" !!!!!!!!!

I dont know if it is my computer...but the date column is not recognized WHY??????? (should be the data source???)

 

Any help would be so much appreciated!!!!! CLICK the link below to get the excel sheet and the pbix.

 

https://www.dropbox.com/sh/7c8flnkv9an4wid/AABcK56rpTF6tSSM3KmCSzm5a?dl=0

  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    I wrote a calculated column formula to extract the Date only from the Date/time column.  I used the INT() function to do so.

     

    Hope this helps.

7 Replies

    • christianfcbmx's avatar
      christianfcbmx
      Icon for Post Patron rankPost Patron

      Hi Ashish_Mathur can you tell me what was the problem? everbody wants to know what happened and what to do in a situation like that in the future! :)

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User

        Hi,

         

        I wrote a calculated column formula to extract the Date only from the Date/time column.  I used the INT() function to do so.

         

        Hope this helps.