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 have a column with a date and time.
I need to keep the date, but change the time to always be 15:00
I have tried different but no luck.
Custom column = Date.From([#"Column"]) + #duration(0,15,0,0)
Regards
Tony
Solved! Go to Solution.
You could try constructing a datetime and hardcoding the time .
Here's a start:
#datetime(Date.Year([Column1]), Date.Month([Column1].....
You could also use DateTime.ToText and DateTime.FromText like this:
DateTime.FromText(DateTime.ToText([Column], [Format="yyyy-MM-dd 15:00:00"]))
Hi @HotChilli
Worked perfect Thank you
#datetime(Date.Year([#"M&P deadline"]),Date.Month([#"M&P deadline"]),Date.Day([#"M&P deadline"]),15,00,00)
You could try constructing a datetime and hardcoding the time .
Here's a start:
#datetime(Date.Year([Column1]), Date.Month([Column1].....
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.