develohpanda/RoundToNearestXSeconds.txt

Created September 19, 2016 01:27

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/develohpanda/a6d60949e0378b4b708a5ce9aa96ca24.js"></script>
Save develohpanda/a6d60949e0378b4b708a5ce9aa96ca24 to your computer and use it in GitHub Desktop.

Download ZIP

Power BI - Round to nearest x seconds

Raw

RoundToNearestXSeconds.txt

DateTime.From(Number.Round((Number.From([Time]) * 24 * 3600)/RoundToNearestXSecond, 0)*RoundToNearestXSecond/(24*3600))

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment