💰 Ever tried processing payments on a holiday? Yeah, banks just laugh at you. 🤡 I wrote a Power Query function that skips weekends and holidays to get the next banking day—because money waits for no one (except financial institutions).

Check it out: https://deuts.org/p/power-query-next-banking-day/

#PowerQuery
#Mlanguage
#FinancialTech
#DataScience

💰 Ever tried processing payments on a holiday? Yeah, banks just laugh at you. 🤡 I wrote a Power Query function that skips weekends and holidays to get the next banking day—because money waits for no one (except financial institutions).

Check it out: https://deuts.org/p/power-query-next-banking-day/

#PowerQuery #Mlanguage #FinancialTech #DataScience

Looking at writing some Power Query M language to page results from an API. I'm distressed to learn that instead of the universal "return", M language uses the keyword "in" to indicate the return value.

Also I'm struggle to see how to debug this (there is no print command!).

I hate languages that live in little boxes...

#PowerQuery #Excel #Mlanguage

18.1 Introduction to M Language in Power BI (Power Query) | Power BI Tutorial for Beginners

powerbi #mlanguage #mfunctions What is M Language in Power BI? You will learn M Language in Power Query Power BI In this ... source

https://quadexcel.com/wp/18-1-introduction-to-m-language-in-power-bi-power-query-power-bi-tutorial-for-beginners/