Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Goodday,
I have a CSV file withe a data-time field witch has the format (Jan 12, 2024 @ 19:39:03.793).
Is there a way to convert this format to a DD-MM-YYYY, HH:MM:SS ?
Solved! Go to Solution.
DateTime.ToText(
DateTime.FromText("Jan 12, 2024 @ 19:39:03.793", [Format = "MMM dd, yyyy '@' HH:mm:ss.fff"]),
[Format = "dd-MM-yyyy, HH:mm:ss"]
)
DateTime.ToText(
DateTime.FromText("Jan 12, 2024 @ 19:39:03.793", [Format = "MMM dd, yyyy '@' HH:mm:ss.fff"]),
[Format = "dd-MM-yyyy, HH:mm:ss"]
)
I can't find the DateTime.ToText function in dax
@Roost1969 it's Power Query forum. By default you are requesting a help with M, not DAX.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 4 | |
| 3 | |
| 2 |
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 8 | |
| 7 | |
| 7 |