GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → tirnovar → m-custom-functions

tirnovar / m-custom-functions

Licence: other
This library contains created mostly pure M-functions without any other languages.

Labels

querypowerbiquery-languagepowerquerypowerquerym

Projects that are alternatives of or similar to m-custom-functions

vaultaire
Query DSL and data access utilities for Corda developers.
Stars: ✭ 14 (-41.67%)
Mutual labels:  query, query-language
Purescript Selda
A type-safe, high-level SQL library for PureScript
Stars: ✭ 72 (+200%)
Mutual labels:  query, query-language
LibPQ
Detach your M code from workbooks to reuse it! Import modules from local or web storage (unlimited number of sources)
Stars: ✭ 55 (+129.17%)
Mutual labels:  powerbi, powerquery
PowerBI-book-ru
Проект открытого методического пособия по Power BI, Power Query, Power Pivot
Stars: ✭ 76 (+216.67%)
Mutual labels:  powerbi, powerquery
Power-Query-Excel-Formats
A collection of M code to get various formats from Excel sheets in Power Query
Stars: ✭ 43 (+79.17%)
Mutual labels:  powerbi, powerquery
powerbi
Repository with links and files for using in PowerQuery and PowerBI
Stars: ✭ 32 (+33.33%)
Mutual labels:  powerbi, powerquery
typeql
TypeQL: the query language of TypeDB - a strongly-typed database
Stars: ✭ 157 (+554.17%)
Mutual labels:  query, query-language
Rapidql
Query multiple APIs and DBs and join them in a single query
Stars: ✭ 91 (+279.17%)
Mutual labels:  query, query-language
PowerQueryConnectors
A collection of data connectors for Power BI
Stars: ✭ 30 (+25%)
Mutual labels:  powerbi, powerquery
Ldflex
A JavaScript DSL for querying Linked Data on the Web
Stars: ✭ 123 (+412.5%)
Mutual labels:  query, query-language
PowerQueryNet
Run M Language (Power Query Formula Language) from anywhere.
Stars: ✭ 146 (+508.33%)
Mutual labels:  powerbi, powerquery
kql
Kirby's Query Language API combines the flexibility of Kirby's data structures, the power of GraphQL and the simplicity of REST.
Stars: ✭ 120 (+400%)
Mutual labels:  query, query-language
miniql
A tiny JSON-based query language inspired by GraphQL
Stars: ✭ 121 (+404.17%)
Mutual labels:  query, query-language
express-mquery
Expose mongoose query API through HTTP request.
Stars: ✭ 37 (+54.17%)
Mutual labels:  query
joern
Open-source code analysis platform for C/C++/Java/Binary/Javascript/Python/Kotlin based on code property graphs
Stars: ✭ 968 (+3933.33%)
Mutual labels:  query-language
twinql
A graph query language for the semantic web
Stars: ✭ 17 (-29.17%)
Mutual labels:  query-language
PowerBI-visuals-AttributeSlicer
Attribute Slicer custom visual for PowerBI
Stars: ✭ 24 (+0%)
Mutual labels:  powerbi
poweRbi
An R-based, httr-style interface for the Power BI REST API.
Stars: ✭ 17 (-29.17%)
Mutual labels:  powerbi
powerbi-visuals-chartxkcd
Power BI custom visual, providing an interface to chart.xkcd
Stars: ✭ 37 (+54.17%)
Mutual labels:  powerbi
elastic-composer
Client-side Elasticsearch query generator and executor. Filter fields, find search suggestions, and paginate query results for your indicies using a simple, reactive, and high-level API
Stars: ✭ 14 (-41.67%)
Mutual labels:  query
View All Similar Projects ➔

DataBrothers Power Query Custom Function Library

This repository has been created as an open-source library of Štěpán Rešl - DataBrothers s.r.o.

This library contains mostly pure M-functions without any other languages.

General Functions:

Method Name Description Language
Create DateKey Returns a DateKey table with a list of working days based on a list of holidays that can be defined as a separate list. M
Get EasterDate Returning Date of Easter Sunday for inputted Year. M
Get DataToJson Returns inputted table as a one JSON structure. M + R
Get CumulatedValueByCategoryAndPreviousDates Return cumulated summary by specific category and previous dates. This function required Table, String names of columns: {Cumulation, Category, Date} and Columns thats will be used as Category and DateKey M
Get RangeOfNumbers Return list of numbers between start number and latest number that an inputted count of digits can create. If you use "true" and fromStart variables, then numbers will be added to the start; otherwise, it will end. M
Get ServiceDeskIssuesDataFromJiraCloud Getting all data of issues from JIRA CLOUD (including history). M
Get WorkingMDBetweenDatesAndByWorkingHours Returning Time between StartDateTime and EndDateTime by Working hours and working days (without weekends). M
Get AllWorldCountriesWithDetails Geting table of wold Countries with details about them. M
Get NumbersFromText Returns all numbers from input text source M
Get TableOfLanguages Returns a table with all defined languages and their short codes. M
Send DataToPowerAutomateAsJSON Sending JSON structured data to Power Automate HTTP endpoint and returning TEXT value Send or Something happened. M

Microsoft Graph API:

Method Name Description Language
Get TableOfUsersFromMicrosoftGraphAPI Getting table with data from Microsoft Graph API about Users. You have to create OWN Azure Aplication in Azure Active Directory with API Permisons: {User.Read, Reports.Read.All, Directory.Read.All} M

Storyous Functions:

Method Name Description Language
Get StoryousAPIKey Returns Bearer API Token for Storyous API M
Get StoryousDataOfMarketPlaceBillsByAPI Returns all data from Storyous API of Market, Places and Bills M
Get StoryousDataUniverzalWithoutRecursion This function is great to use if you need to get specific table from Storyous API M

🇨🇿 Functions:

Method Name Description Language
Get ExchangeRateOfCZK Returns Table of Exchange rate of all currencies from ČNB to CZK M
Get Inflace z ČNB Returns Inflace from ČNB (Česká Národní Banka) M

Custom Function Template

Name Description
Custiom Function Tempalte Here is my template for developing custom #PowerQuery functions
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].