如何在Power Query中执行相当于AddHours的DateTime？ [英] How can I perform the equivalent of AddHours to a DateTime in Power Query?

问题描述

我看过PowerQuery表达式可以从datetime中减去日期，例如DateTimeZone.UtcNow.AddDays（-1）。但是，我想从DateTime而不是几天减去小时。

由于我没有看到像AddHours（）在Power Query规范中，有一个强大的方法可以回到几个小时？例如，像DateTimeZone.UtcNow + #duration（0，-1,0,0）给我的东西一个小时前的DateTime？

[注意：我自己尝试一下，但是我无法在我的本地盒子上安装Power Query，我找不到一个独立的编辑，尝试它，因此社区问]

解决方案

是的，添加 #duration（0 ，-1，0，0）将给你一个小时前的DateTime。您还可以从DateTime值中减去 #duration（0，1，0，0）。这些方法是稳健的。

I've seen PowerQuery expressions that can subtract days from a datetime, like DateTimeZone.UtcNow.AddDays(-1). However, I'd like to subtract hours from a DateTime, not days.

As I don't see a function like AddHours() in the Power Query specification, is there a robust way to go back a number of hours? For instance, would something like DateTimeZone.UtcNow + #duration(0, -1, 0, 0) give me a DateTime that's one hour earlier?

[Note: I'd try this myself but I can't get Power Query installed on my local box and I can't find an independent editor to try it, hence the community ask]

解决方案

Yes, adding #duration(0, -1, 0, 0) would give you a DateTime that is one hour earlier. You could also subtract #duration(0, 1, 0, 0) from the DateTime value. These methods are robust.

这篇关于如何在Power Query中执行相当于AddHours的DateTime？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！