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
how can i make my date of my date/time column relative to today?
i want to avoid going into my data everyday and changing the date
= Table.AddColumn(#"Filtered Rows", "AM/PM", each if [ST] <= #datetime(2023, 1, 20, 13, 50, 0) then "AM" else "PM")
ST | ||
21/01/2023 04:30:00 | AM | |
21/01/2023 20:30:00 | PM | |
21/01/2023 06:30:00 | AM | |
21/01/2023 14:30:00 | PM | |
21/01/2023 13:30:00 | AM |
Solved! Go to Solution.
Hi,
In that case you can add the time like this:
newDate = Date.From(DateTime.LocalNow()) & Time.FromText("13:50:00pm"),
next_step = Table.AddColumn(#"Replaced Value", "AM/PM", each if [ST] <= newDate then "AM" else "PM")
Proud to be a Super User!
Hi,
Try using DateTime.LocalNow() function.
E.g.
= Table.AddColumn(#"Replaced Value", "AM/PM", each if [ST] <= DateTime.LocalNow() then "AM" else "PM")
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
hi,
thanks for reply.
i need the time 13:50 to be fixed - AM will always be below 13:50 and PM after.
kr
Hi,
In that case you can add the time like this:
newDate = Date.From(DateTime.LocalNow()) & Time.FromText("13:50:00pm"),
next_step = Table.AddColumn(#"Replaced Value", "AM/PM", each if [ST] <= newDate then "AM" else "PM")
Proud to be a Super User!
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 |
---|---|
46 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
61 | |
50 | |
45 | |
20 | |
17 |