Brent JonesMar 18, 2023What is the Difference Between FILTER and CALCULATETABLE?What is the Difference Between FILTER() and CALCULATETABLE()?
Brent JonesFeb 11, 2023Using 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?