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 *****
How To Handle Stacked Data In Power BI – https://youtu.be/iK3elM1arOk

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

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