For this tutorial, Brian is going to demonstrate how you can transform messy stacked data into a more organized format. There’s quite an easy way to do this, and it’s one that is going to be incredibly useful and has a lot of different application.
***** Video Details *****
00:00 Introduction
01:32 Raw data
03:25 Modulo
04:56 Text.Remove
06:30 Pivot column
7:50 Remove alternate rows
***** Related Links *****
Power BI Buried Treasures: Modulo and Integer-Divide – https://youtu.be/ArcTJ7X1U7E
***** 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