How to Create And Debug Custom Functions In Power BI

For today, we’re going to continue on the topic of last Wednesday’s video wherein we dealt with a common difficult-to-handle format of stacked data and how we can use Modulo, Pivot and some cleaning functions with Power Query to transform that date into an organized and functional format. In this video, we’re going to build a custom function that’s going to make this technique easily reusable on multiple reports and multiple tables.

***** Video Details *****
00:00 Introduction
02:00 Reusing M Code
03:03 Setting parameters
06:59 Invoke
07:46 Debugging
08:15 Function to query
11:51 Query to function

***** Related Links *****

***** Learning Power BI? *****

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerQuery #PowerQueryTutorial

[mehdihammadi]

Very interesting content. Thanks for sharing Brian.👍

[RobertoStaltari]

This debugging tip is exacly what you need to know before starting coding in M. Thanks Brian!

[wayneedmondson]

Great one Brian! Thanks for sharing these tips. Thumbs up!!

[techietips]

Thanks for sharing.
Where can I download the sample data?

[sivachaitanya]

i dont know what is setting parameter or advansed editor uses how can i understand this video is there a video that explains the basics in this