Uploaded March 2026 | Updated November 2026, 1 hour ago
In this installment of "50 Excel Formulas in 50 Days" we explore a mind-boggling trick to calculate the maximum streak of increasing shipment values. Learn how to use excel formulas and functions and the lambda function to identify and count consecutive increases in your data. This excel tutorial will enhance your excel tricks for data analysis.
#excel #chandoo
In this installment of "50 Excel Formulas in 50 Days" we explore a mind-boggling trick to calculate the maximum streak of increasing shipment values. Learn how to use excel formulas and functions and the lambda function to identify and count consecutive increases in your data. This excel tutorial will enhance your excel tricks for data analysis.
#excel #chandoo

![How to Self-Join Tables in Power Query [Step-by-step Tutorial]
Use Power Query self-joins to solve tricky data challenges.
In this example, I share how I am using self-joins to get the prior weekly rental and prior move out date from rental agreement data with Power Query.
Sample data file: https://chandoo.org/wp/wp-content/uploads/2025/08/self-join-example.xlsx
Need Power BI Skills for yourself?
Join my Power BI course - https://chandoo.org/wp/power-bi-course/
~
A data engineer got divorced. When friends ask her what happened, she replied,
I left the join because it wasnt the right join. ๐
#powerbi #powerquery How to Self-Join Tables in Power Query [Step-by-step Tutorial]](https://i.ytimg.com/vi/yPTbywOkXIo/mqdefault.jpg)




