Brent JonesMar 18The Best Guide to FILTER() and CALCULATETABLE() DifferencesIn this article, I clearly layout the differences when using FILTER or CALCULATE TABLE.
Brent JonesFeb 11Using a Custom Function Within List.Generate()Looping with the M language is not easy. What if you want to loop a custom function and break out of the loop based on the functions return
Brent JonesOct 6, 2022Calculating Business Days and Hours Between Two Dates (DAX)Power BI DAX has a function called "NETWORKDAYS()". However it does not calculate hours. If you need to calculate hours, you can use this...
Brent JonesAug 7, 2021Power BI: How to Remove Duplicates and Keep Most Recent?How to remove duplicate records while ensuring that you keep the most recent item?
Brent JonesOct 28, 2019Displaying Unity's Game Build LogIf you ever want or need to display Unity's build report with graphs and charts, you can do that with Power BI. The set up takes a coupl
Brent JonesJun 8, 2019Exploring "Overtourism" with Power BI (Part 1)The alien walks us through a comparison of increases in tourism per country per year. Also go over some Power Query and DAX tips including A
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 JonesDec 18, 2018Want to Build Your Own Neural Network With Python?Book review for "Make Your Own Neural Network" by Tariq Rashid. Excellent job of explaining the concepts in an easy-to-understand
Brent JonesOct 29, 2018Power BI: Ultimate Guide to the Basics of Importing DataTo begin, click on the "Get Data" button on the Home tab of Power BI. This will bring up a new window with several options.
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 13, 2018Power Query: Preventing "The column of the table wasn't found" errorRead about how to prevent errors resulting from column name changing.
Brent JonesAug 9, 2018How to Make a Cells Value a Power Query ParameterCreate easily editable parameters in Excel for Power Query to help your users. Use a named range in Excel for the query source. You can then