Date format in pbi

[itso]

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

[v-caliao-msft]

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

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]

@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

[itso]

Somebody?

[Anonymous]

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

[itso]

It's not active - not posible.