Incorporating M In Custom Column - Problem Of The Week #9 (Power Query Solution)

In this video, I will walk through a complete solution to Problem of the Week #9 including a simple and generalizable framework for incorporating M code into a custom column. Being able to create columns in Power Query using M code dramatically increases your ability to solve more complex problems.

Brian

The Problem of the Week initiative is open to members and non-members with the goal to improve Power BI skills through practical application.

***** Video Details *****
00:00 Introduction
03:23 Conceptual model
05:03 Tweinzapfel’s solution
05:49 How to do a count
06:57 Data table
07:30 Group by
09:57 Sorting by ascending date
12:28 Table.AddIndexColumn
16:08 Merge queries
20:13 Connecting date field into the data model
20:45 Image URL field
22:01 Date setup

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

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

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

[stevenstanford]

Thank you. Great learning and resource

[NearbyCactus]

Thanks, I really got a lot from this!

[darrylmorgan]

Really Helpful Tips And Tricks...Thank You Brian

[darrengodkin]

Very helpful and useful new knowledge for myself, thanks for sharing Brian.

[EnterpriseDNA]

There is so many fantastic techniques covered in this video from start to finish. Love the tips and flow around Power Query.