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 ...
Need Help
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