cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
itso Frequent Visitor
Frequent Visitor

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.

 

image.png

 

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

Have someone any idea?

Thanks a lot

6 REPLIES 6
itso Frequent Visitor
Frequent Visitor

Re: Date format in pbi

Somebody?

Highlighted
AfriKan Frequent Visitor
Frequent Visitor

Re: Date format in pbi

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

itso Frequent Visitor
Frequent Visitor

Re: Date format in pbi

It's not active - not posible.

Moderator v-caliao-msft
Moderator

Re: Date format in pbi

@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))

Capture.PNG

 

Regards,

Charlie Liao

itso Frequent Visitor
Frequent Visitor

Re: Date format in pbi

Hi Charlie,


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

 

Itso

 

 

Moderator v-caliao-msft
Moderator

Re: Date format in pbi

@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