Forum Discussion
DATETIME Column
Hi there, I have a datetime field in the format "20/11/2023 20:33:45". I would like to create a new column that ages this datetime value against the current system datetime value (e.g. today's da...
On the 'Add Column' tab, If you select both columns, you can use the Time section (it will activate a Subtract menu item). This will subtract one column from the other and give you a duration. This is when the fun starts.
You can use duration in Power Query but DAX doesn't know how to deal with it in a way that you probably want. There are lots of functions to give you minutes from a duration and (on the forum and the web) you will find ways to get that as a text field in days,hrs, minutes, seconds
Apologies for the late reply and thank you for the suggestions. I will have a play with Power Query and report back 😀.
Thanks again.
