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 community,
How to removed the delimiter between this date format 04/11/2020 for have this format 20200411 ?
Have a good day and thanks !
Solved! Go to Solution.
Which date format did you input ? Also, before this new column... is your column formated as date ?
Get this new code:
Date.ToText([Column1], "yyyyMMdd")
I missed the upper double M.
It's not a problem, if null it will return null.
Which date format did you input ? Also, before this new column... is your column formated as date ?
Get this new code:
Date.ToText([Column1], "yyyyMMdd")
I missed the upper double M.
It's OK ! Thank you so much !
Expanding on what @camargos88 provided, when adding the new column, test for null
if [Date] <> null then Date.ToText ([Date], "yyyymmdd") else "Invalid Date"
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 |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |