web
You’re offline. This is a read only version of the page.
close
Skip to main content

Power BI

New

Support Teradata Query Folding of Date and DateTime Arithmetic

Vote (11) Share
Mark Weisman's profile image

Mark Weisman on 22 Jun 2017 23:16:51

For example, #"Added Custom" = Table.AddColumn ( #"Removed Other Columns", "Custom", each Duration.Days ( [ROW_MODIFY_GMT_DTTM] - [ROW_CREATE_GMT_DTTM] )) ... should query fold. In Teradata subtraction of 2 dates produces the days between the 2 dates.