Brent JonesSep 23, 20192 Easy Steps to Loop with Power Query! List.Accumulate()Here's the situation: I have a list of values (text/string). I want to create one single concatenated string based on that list.
Brent JonesApr 26, 2019Power BI's "Automagical" Column From Example Feature (for any web page!)Power BI has a somewhat hidden feature you may not have know existed - or maybe you knew about it but haven't given it a thought to try
Brent JonesNov 24, 2018Improbably Unhelpful Power Query / M Custom Functions that You Might Not Never Use.This is a collection of Power Query / M functions that I've used in the past. I'm using this article as an open collection so that y
Brent JonesNov 12, 2018Power BI: Top 10 Companies in GA - Plus Nested Queries​How do the top 10 companies in GA and their respective tax payment in 2018 line up? Plus, a look at nesting queries within queries.
Brent JonesSep 21, 2018Get Worksheet Data In the Current Workbook With Power QueryYou may already be familiar with the "Get Data" function in Excel. You can use this feature to send data from your worksheet to Po
Brent JonesAug 22, 2018Power BI: Creating a Function with PythonRead about how to create a Python function in Power Query!
Brent JonesAug 20, 2018Power BI: Building a Digital Nomad DashboardRead about how to make a Power BI dashboard to help you make a decision on the best countries to visit for a Digital Nomad Excursion!