Function Junction
What Is Function Junction?
I dabble a lot with functional programming. I like writing short snippets of code to help me calculate, visualize, or automate something. This page is essentially a library of what I have in my GitHub Gists and will be updated as I figure out things.
M
- fnCheckColorBlindness – Check Hex Code for Color Blindness Impact
- fnColorFade – Generate a table to tint and fade a color
- fnCreateBatches – Create batches for pagination
- fnCreateDimID – Replace Column in Fact Table with Surrogate Key
- fnCreateDimTables – Create One Column Dim Tables From Text Columns
- fnCreateMultiColDim – Create a Multi-Column Dim Table from Fact Table Columns
- fnCreateMultiDimId – Create Surrogate IDs for Multi-Column Dim Table
- fnErlangC – Use ErlangC Algorithm to Calculate Service Level and Staffing
- fnGetHue – Get hue of a color
- fnGetLuminosity – Get luminosity of a color
- fnGetQuartileStats – Get quartile and other statistical information for numerical column
- fnGetRGBFromHex – Get RGB Value from Hex Code
- fnGetZScore – Get the z score for a numerical column
- fnMedianAspectRatio – Get median aspect ratio of values of a chart for optimal aspect ratio
- fnMegaAverage – Calculate Alternate Means for a List
- fnPearson – Get Pearson Correlation Coefficient using Power Query
- fnPyRegexMatch – Basic function to use regular expressions with Power Query and Python
- fnRenameColumns – Rename all columns by removing underscore and replacing with space
- fnRoundDateTime – Round Date/Colum to Nearest Minute Increment
- fnSpacyLocations – Get locations from text using spacy library in Python and Power Query
- fnSwitch – Function to mimic SWITCH() in DAX
- fnSwitchMethod -Switch text values based on different methods like contains and starts with
- fnZTable – Use the Standard Distribution Table with Power Query
Python