Skip to content

IvanBond/PowerQueryModules

Repository files navigation

PowerQueryModules

Power Query Modules used in Power BI Desktop

These Modules were harvested from the Power BI Desktop
Assembly location: C:\Program Files\Microsoft Power BI Desktop\bin\Microsoft.MashupEngine.dll

Contents of the modules:

##Module.List.m

  • List.NonNullCount
  • List.MatchesAll
  • List.MatchesAny
  • List.Range
  • List.RemoveItems
  • List.ReplaceValue
  • List.FindText
  • List.RemoveLastN
  • List.RemoveFirstN
  • ContainsTextWithin

##Module.Date.m

  • Date.IsInPreviousDay
  • Date.IsInPreviousNDays
  • Date.IsInCurrentDay
  • Date.IsInNextDay
  • Date.IsInNextNDays
  • Date.IsInPreviousWeek
  • Date.IsInPreviousNWeeks
  • Date.IsInCurrentWeek
  • Date.IsInNextWeek
  • Date.IsInNextNWeeks
  • Date.IsInPreviousMonth
  • Date.IsInPreviousNMonths
  • Date.IsInCurrentMonth
  • Date.IsInNextMonth
  • Date.IsInNextNMonths
  • Date.IsInPreviousQuarter
  • Date.IsInPreviousNQuarters
  • Date.IsInCurrentQuarter
  • Date.IsInNextQuarter
  • Date.IsInNextNQuarters
  • Date.IsInPreviousYear
  • Date.IsInPreviousNYears
  • Date.IsInCurrentYear
  • Date.IsInNextYear
  • Date.IsInNextNYears
  • Date.IsInYearToDate
  • DateTime.IsInPreviousSecond
  • DateTime.IsInPreviousNSeconds
  • DateTime.IsInNextSecond
  • DateTime.IsInNextNSeconds
  • DateTime.IsInCurrentSecond
  • DateTime.IsInPreviousMinute
  • DateTime.IsInPreviousNMinutes
  • DateTime.IsInNextMinute
  • DateTime.IsInNextNMinutes
  • DateTime.IsInCurrentMinute
  • DateTime.IsInPreviousHour
  • DateTime.IsInPreviousNHours
  • DateTime.IsInNextHour
  • DateTime.IsInNextNHours
  • DateTime.IsInCurrentHour
  • Date.MonthName
  • Date.DayOfWeekName
  • StartOfHour
  • StartOfMinute
  • StartOfSecond

##Module.SharePoint15.m

  • SharePoint15.Tables
  • SharePoint15.Contents
  • SharePoint15.Files
  • ContentSchemaWithZone
  • CreateContent
  • CreateFiles
  • ContentSchema
  • CreateFolderContent
  • CreateFilesContent
  • TransformToFolder
  • TransformToFile
  • TransfromFromFileList
  • TransformToFiles
  • GetFileExtension
  • NormalizeExtension
  • GetFileKind
  • GetUrlAuthority
  • GetFileDirectory
  • NormalizeFolderPath
  • GetParentFolder
  • ToNavigationTable

##Module.SqlExpression.m

  • SqlExpression.SchemaFrom

##Module.Text.m

  • Text.Format
  • Text.FormatGetPlaceholders
  • Text.FormatToText

##Module.Table.m

  • ColumnsSelector.CreateColumnsList
  • ColumnsSelector.CreateListKeySelector
  • TableColumnTransformOperations.CreateTransformOperationsList
  • TableEquationCriteria.CreateListEquationCriteria
  • TableEquationCriterion.CreateListEquationCriterion
  • TableEquationCriterion.IsTableEquationCriterion
  • TableEquationCriterion.Default
  • TableRowReplacementOperation.CreateListReplacementOperation
  • TableRowReplacementOperation.IsTableRowReplacementOperation
  • TableRowReplacementOperations.CreateListReplacementOperations
  • Table.ColumnCount
  • Table.AlternateRows
  • Table.InsertRows
  • Table.LastN
  • Table.Last
  • Table.MatchesAllRows
  • Table.MatchesAnyRows
  • Table.Partition
  • Table.Range
  • Table.RemoveRows
  • Table.Repeat
  • Table.ReplaceRows
  • Table.ReverseRows
  • Table.HasColumns
  • Table.PrefixColumns
  • Table.ColumnsOfType
  • Table.AddColumn
  • Table.DuplicateColumn
  • Table.FillUp
  • Table.RemoveLastN
  • Table.RemoveFirstN
  • Table.ExpandListColumn
  • Table.ExpandTableColumn
  • Table.TransformRows
  • Table.Transpose
  • Table.DemoteHeaders
  • Table.ToRows
  • Table.ToColumns
  • GetListEquationCriteria
  • GetTableContainsEquationCriteria
  • Table.Contains
  • Table.ContainsAll
  • Table.ContainsAny
  • Table.IsDistinct
  • Table.PositionOf
  • Table.PositionOfAny
  • Table.RemoveMatchingRows
  • Table.ReplaceMatchingRows
  • Table.Max
  • Table.MaxN
  • Table.Min
  • Table.MinN
  • Table.Buffer
  • Table.FindText
  • Replacer.ReplaceValue
  • Replacer.ReplaceText
  • Table.ReplaceValue
  • Table.ReplaceValueSlow
  • Table.TransformColumnsWithRowContext
  • Record.TransformFieldsWithRowContext
  • Record.FromList
  • Table.IsEmpty
  • Table.SplitColumn
  • Table.CombineColumns
  • Table.FirstValue
  • IsTrueSelector
  • GetHandler
  • Delta.SinceInternal
  • TableAction.InsertRowsInternal
  • TableAction.UpdateRowsInternal
  • TableAction.DeleteRowsInternal
  • ValueAction.NativeStatementInternal
  • Handlers.FromTable
  • Handlers.AddDefaults
  • Table.View
  • Table.Schema
  • Type.TableSchema
  • Table.Profile

About

Power Query Modules used in Power BI desktop

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published