Sometimes It's Good to Fail: Raising Errors with Data Quality Tests
Having your dataflows or semantic models fail to refresh can be frustrating, but at least you know that whatever caused the error did not make it into your...
Power Query¶
Custom M Function #7: fxReplaceWithDefaultValue
Click here to go straight to the function.
Custom M Function #6: fxSplitCamelCaseColumns
Click here to go straight to the function.
Custom M Function #5: fxCumulativeToIncremental
Click here to go straight to the function.
Power Query Level Up: Exploring the Advanced Editor and the M Language
Recently, I had the privilege of delivering my first public training session at the 2024 Global Power Platform Bootcamp where I gave an introduction to the...
Custom M Function #4: fxSetColumnTypesFromModel
Click here to go straight to the function.
Custom M Function #3: fxSplitCamelCaseText
Click here to go straight to the function.
Custom M Function #2: fxGenerateSurrogateKeyColumn
Click here to go straight to the function.
Custom M Function #1: fxJoinAndExpandTable
Click here to go straight to the function.
Intro to Custom M Functions
I have been spending a lot of time in Power Query lately, and one thing that I have been trying to do is to compile a custom M function library that I can...
