Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
I want custom column formula for changing date format 7/28/2023 9:10:02 AM to 2023-7-28 9:10:02 in poewrbi Desktop. How can I achieve this and the data is in Direct Query Mode.
Solved! Go to Solution.
Hi @ompraashkumawat ,
As far as I know, calculated column by FORMAT function will return a column in text data type instead of date data type.
I suggest you to add a custom format in model view.
Select the column and change the format as below.
yyyy-mm-dd hh:mm:ss AM/PM
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ompraashkumawat ,
As far as I know, calculated column by FORMAT function will return a column in text data type instead of date data type.
I suggest you to add a custom format in model view.
Select the column and change the format as below.
yyyy-mm-dd hh:mm:ss AM/PM
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
CalculatedColumn = FORMAT(YourTable[YourDateColumn], "yyyy-mm-dd hh:nn:ss AM/PM")
If this helps you then please mark my solution as accepted so that others can find it quickly on facing similar issues. Thank You!
probably yes!
plse try this
Column = FORMAT([Column1],"yyyy-mm-dd hh:mm:ss")
I am getting this error. Is it due to Direct Query Mode?
I am getting this error. Is it due to Direct Query Mode?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
146 | |
111 | |
109 | |
103 | |
96 |