Forum Discussion

itso's avatar
itso
Icon for Advocate I rankAdvocate I
9 years ago

Date format in pbi

Hi

I'm connecting direct query to SAP BW.

I have a date field that for some reason, pbi detect like text.

I try diferent regional settings, but everitame format it was text and it not possible to change it.

 

 

Because i'm in direct, i cant transform the column.

Have someone any idea?

Thanks a lot

Need Help

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      What does it do if you try and change the Data type to Date?

      • itso's avatar
        itso
        Icon for Advocate I rankAdvocate I
        9 years ago

        It's not active - not posible.

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    itso,

     

    You could create a calculate column by using the DAX expression below.
    Column = DATE(MID(Table2[Date],7,4),MID(Table2[Date],4,2),MID(Table2[Date],1,2))

     

    Regards,

    Charlie Liao

    • itso's avatar
      itso
      Icon for Advocate I rankAdvocate I
      9 years ago

      Hi Charlie,


      I couldn't create calculated column, because i'm in direct query and options is only creation a measure.

       

      Itso

       

       

      • v-caliao-msft's avatar
        v-caliao-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        itso,

         

        If that is that case, you could create a column in your source database. Besides, we can create calcualted column in directquery mode.

         

        Regards,

        Charlie Liao