# Data Transformation

- [Formulas](/data-transformation/formulas.md)
- [What are Formulas?](/data-transformation/formulas/what-are-formulas.md)
- [Math Functions](/data-transformation/formulas/math-functions.md)
- [Abs](/data-transformation/formulas/math-functions/abs.md)
- [Ceiling](/data-transformation/formulas/math-functions/ceiling.md)
- [Exp](/data-transformation/formulas/math-functions/exp.md)
- [Floor](/data-transformation/formulas/math-functions/floor.md)
- [IsEven](/data-transformation/formulas/math-functions/iseven.md)
- [IsOdd](/data-transformation/formulas/math-functions/isodd.md)
- [Ln](/data-transformation/formulas/math-functions/ln.md)
- [Log](/data-transformation/formulas/math-functions/log.md)
- [Log10](/data-transformation/formulas/math-functions/log10.md)
- [Mod](/data-transformation/formulas/math-functions/mod.md)
- [Pi](/data-transformation/formulas/math-functions/pi.md)
- [Power](/data-transformation/formulas/math-functions/power.md)
- [Quotient](/data-transformation/formulas/math-functions/quotient.md)
- [Round](/data-transformation/formulas/math-functions/round.md)
- [RoundDown](/data-transformation/formulas/math-functions/rounddown.md)
- [RoundUp](/data-transformation/formulas/math-functions/roundup.md)
- [Sign](/data-transformation/formulas/math-functions/sign.md)
- [Sqrt](/data-transformation/formulas/math-functions/sqrt.md)
- [Truncate](/data-transformation/formulas/math-functions/truncate.md)
- [Trigonometric Functions](/data-transformation/formulas/trigonometric-functions.md)
- [Acos](/data-transformation/formulas/trigonometric-functions/acos.md)
- [Asin](/data-transformation/formulas/trigonometric-functions/asin.md)
- [Atan](/data-transformation/formulas/trigonometric-functions/atan.md)
- [Atan2](/data-transformation/formulas/trigonometric-functions/atan2.md)
- [Cos](/data-transformation/formulas/trigonometric-functions/cos.md)
- [Cot](/data-transformation/formulas/trigonometric-functions/cot.md)
- [Degrees](/data-transformation/formulas/trigonometric-functions/degrees.md)
- [Radians](/data-transformation/formulas/trigonometric-functions/radians.md)
- [Sin](/data-transformation/formulas/trigonometric-functions/sin.md)
- [Tan](/data-transformation/formulas/trigonometric-functions/tan.md)
- [String Functions](/data-transformation/formulas/string-functions.md)
- [Compare](/data-transformation/formulas/string-functions/compare.md)
- [Concat](/data-transformation/formulas/string-functions/concat.md)
- [Contains](/data-transformation/formulas/string-functions/contains.md)
- [In](/data-transformation/formulas/string-functions/in.md)
- [CountMatches](/data-transformation/formulas/string-functions/countmatches.md)
- [CountMatchesRegexp](/data-transformation/formulas/string-functions/countmatchesregexp.md): Regexp
- [EndsWith](/data-transformation/formulas/string-functions/endswith.md)
- [EndsWithRegexp](/data-transformation/formulas/string-functions/endswithregexp.md)
- [Extract](/data-transformation/formulas/string-functions/extract.md)
- [FindMatchOfString](/data-transformation/formulas/string-functions/findmatchofstring.md)
- [FindMatchOfRegexp](/data-transformation/formulas/string-functions/findmatchofregexp.md)
- [FindMatchesOfString](/data-transformation/formulas/string-functions/findmatchesofstring.md)
- [FindMatchesOfRegexp](/data-transformation/formulas/string-functions/findmatchesofregexp.md)
- [Left](/data-transformation/formulas/string-functions/left.md)
- [Length](/data-transformation/formulas/string-functions/length.md)
- [Lower](/data-transformation/formulas/string-functions/lower.md)
- [Matches](/data-transformation/formulas/string-functions/matches.md)
- [Pad](/data-transformation/formulas/string-functions/pad.md)
- [ProperCase](/data-transformation/formulas/string-functions/propercase.md)
- [RemoveSymbols](/data-transformation/formulas/string-functions/removesymbols.md)
- [RemoveWhitespaces](/data-transformation/formulas/string-functions/removewhitespaces.md)
- [Repeat](/data-transformation/formulas/string-functions/repeat.md)
- [Replace](/data-transformation/formulas/string-functions/replace.md)
- [ReplaceRegexp](/data-transformation/formulas/string-functions/replaceregexp.md)
- [Reverse](/data-transformation/formulas/string-functions/reverse.md)
- [Right](/data-transformation/formulas/string-functions/right.md)
- [Spaces](/data-transformation/formulas/string-functions/spaces.md)
- [Split](/data-transformation/formulas/string-functions/split.md)
- [SplitRegexp](/data-transformation/formulas/string-functions/splitregexp.md)
- [StartsWith](/data-transformation/formulas/string-functions/startswith.md)
- [StartsWithRegexp](/data-transformation/formulas/string-functions/startswithregexp.md)
- [Stuff](/data-transformation/formulas/string-functions/stuff.md)
- [Substring](/data-transformation/formulas/string-functions/substring.md)
- [SubstringDelimiter](/data-transformation/formulas/string-functions/substringdelimiter.md)
- [SubstringRegexpDelimiter](/data-transformation/formulas/string-functions/substringregexpdelimiter.md)
- [Trim](/data-transformation/formulas/string-functions/trim.md)
- [Upper](/data-transformation/formulas/string-functions/upper.md)
- [Date & Time Functions](/data-transformation/formulas/date-and-time-functions.md)
- [Date](/data-transformation/formulas/date-and-time-functions/date.md)
- [DateAdd](/data-transformation/formulas/date-and-time-functions/dateadd.md)
- [DateAdd2](/data-transformation/formulas/date-and-time-functions/dateadd2.md)
- [DateDiff](/data-transformation/formulas/date-and-time-functions/datediff.md)
- [DateDiff2](/data-transformation/formulas/date-and-time-functions/datediff2.md)
- [DateFromParts](/data-transformation/formulas/date-and-time-functions/datefromparts.md)
- [DateTime](/data-transformation/formulas/date-and-time-functions/datetime.md)
- [DateTimeFromParts](/data-transformation/formulas/date-and-time-functions/datetimefromparts.md)
- [DateTrunc](/data-transformation/formulas/date-and-time-functions/datetrunc.md)
- [DayName](/data-transformation/formulas/date-and-time-functions/dayname.md)
- [DayOfMonth](/data-transformation/formulas/date-and-time-functions/dayofmonth.md)
- [DayOfWeek](/data-transformation/formulas/date-and-time-functions/dayofweek.md)
- [DayOfYear](/data-transformation/formulas/date-and-time-functions/dayofyear.md)
- [Hour](/data-transformation/formulas/date-and-time-functions/hour.md)
- [Minute](/data-transformation/formulas/date-and-time-functions/minute.md)
- [Month](/data-transformation/formulas/date-and-time-functions/month.md)
- [MonthName](/data-transformation/formulas/date-and-time-functions/monthname.md)
- [Now](/data-transformation/formulas/date-and-time-functions/now.md)
- [Quarter](/data-transformation/formulas/date-and-time-functions/quarter.md)
- [Second](/data-transformation/formulas/date-and-time-functions/second.md)
- [Time](/data-transformation/formulas/date-and-time-functions/time.md)
- [TimeFromParts](/data-transformation/formulas/date-and-time-functions/timefromparts.md)
- [Today](/data-transformation/formulas/date-and-time-functions/today.md)
- [Week](/data-transformation/formulas/date-and-time-functions/week.md)
- [Year](/data-transformation/formulas/date-and-time-functions/year.md)
- [Aggregate Functions](/data-transformation/formulas/aggregate-functions.md)
- [Any](/data-transformation/formulas/aggregate-functions/any.md)
- [AnyIf](/data-transformation/formulas/aggregate-functions/anyif.md)
- [Array](/data-transformation/formulas/aggregate-functions/array.md)
- [ArrayIf](/data-transformation/formulas/aggregate-functions/arrayif.md)
- [Avg](/data-transformation/formulas/aggregate-functions/avg.md)
- [AvgIf](/data-transformation/formulas/aggregate-functions/avgif.md)
- [AvgInRow](/data-transformation/formulas/aggregate-functions/avginrow.md)
- [Count](/data-transformation/formulas/aggregate-functions/count.md)
- [CountA](/data-transformation/formulas/aggregate-functions/counta.md)
- [CountIf](/data-transformation/formulas/aggregate-functions/countif.md)
- [CountUnique](/data-transformation/formulas/aggregate-functions/countunique.md)
- [Max](/data-transformation/formulas/aggregate-functions/max.md)
- [MaxIf](/data-transformation/formulas/aggregate-functions/maxif.md)
- [MaxInRow](/data-transformation/formulas/aggregate-functions/maxinrow.md)
- [Median](/data-transformation/formulas/aggregate-functions/median.md)
- [MedianIf](/data-transformation/formulas/aggregate-functions/medianif.md)
- [Min](/data-transformation/formulas/aggregate-functions/min.md)
- [MinIf](/data-transformation/formulas/aggregate-functions/minif.md)
- [MinInRow](/data-transformation/formulas/aggregate-functions/mininrow.md)
- [Mode](/data-transformation/formulas/aggregate-functions/mode.md)
- [ModeIf](/data-transformation/formulas/aggregate-functions/modeif.md)
- [Percentile](/data-transformation/formulas/aggregate-functions/percentile.md)
- [Quartile](/data-transformation/formulas/aggregate-functions/quartile.md)
- [StdDev](/data-transformation/formulas/aggregate-functions/stddev.md)
- [StdDevIf](/data-transformation/formulas/aggregate-functions/stddevif.md)
- [Sum](/data-transformation/formulas/aggregate-functions/sum.md)
- [SumIf](/data-transformation/formulas/aggregate-functions/sumif.md)
- [SumProduct](/data-transformation/formulas/aggregate-functions/sumproduct.md)
- [Variance](/data-transformation/formulas/aggregate-functions/variance.md)
- [VarianceIf](/data-transformation/formulas/aggregate-functions/varianceif.md)
- [Conversion Functions](/data-transformation/formulas/conversion-functions.md)
- [ToArray](/data-transformation/formulas/conversion-functions/toarray.md)
- [ArrayToString](/data-transformation/formulas/conversion-functions/arraytostring.md)
- [ToBoolean](/data-transformation/formulas/conversion-functions/toboolean.md)
- [ToDate](/data-transformation/formulas/conversion-functions/todate.md)
- [ToDateTime](/data-transformation/formulas/conversion-functions/todatetime.md)
- [ToDecimal](/data-transformation/formulas/conversion-functions/todecimal.md)
- [ToInteger](/data-transformation/formulas/conversion-functions/tointeger.md)
- [ToObject](/data-transformation/formulas/conversion-functions/toobject.md)
- [ToTime](/data-transformation/formulas/conversion-functions/totime.md)
- [ToString](/data-transformation/formulas/conversion-functions/tostring.md)
- [Misc Functions](/data-transformation/formulas/misc-functions.md)
- [At](/data-transformation/formulas/misc-functions/at.md)
- [IsMissing](/data-transformation/formulas/misc-functions/ismissing.md)
- [RowNumber](/data-transformation/formulas/misc-functions/rownumber.md)
- [Random](/data-transformation/formulas/misc-functions/random.md)
- [If](/data-transformation/formulas/misc-functions/if.md)
- [Coalesce](/data-transformation/formulas/misc-functions/coalesce.md)
- [True](/data-transformation/formulas/misc-functions/true.md)
- [False](/data-transformation/formulas/misc-functions/false.md)
- [Null](/data-transformation/formulas/misc-functions/null.md)
- [$target](/data-transformation/formulas/misc-functions/usdtarget.md)
- [Window Functions](/data-transformation/formulas/window-functions.md)
- [Custom Functions](/data-transformation/formulas/custom-functions.md)
- [Data Types](/data-transformation/formulas/data-types.md): Supported data types and conversion variants between them
- [Supported Date Parts](/data-transformation/formulas/supported-date-parts.md)
- [Regex: List of Tokes](/data-transformation/formulas/regex-list-of-tokes.md)