Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Hi Charlie,
I couldn't create calculated column, because i'm in direct query and options is only creation a measure.
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
Somebody?
What does it do if you try and change the Data type to Date?
It's not active - not posible.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |