Power Query Function that Returns Multiple Values

Posted on July 30, 2015 by Reza Rad

Yesterday in NZ BI user group meeting, I’ve been asked that does Power Query custom functions return only one value as the result set? or they can return multiple values. I’ve answered Yes, and I’ve explained that through a sentence how to do it with Records, List, or Table. Then I thought this might be a question of many people out there. So I’ve wrote this blog post to illustrate how to return multiple values from a custom function in Power Query.

[…]

Day Number of Year, Power Query Custom Function

Posted on July 28, 2015November 30, 2016 by Reza Rad

There are number of Date and DateTime built-in functions in Power Query which are really helpful. There is also a function for DayNumberOfYear. However I’ve thought it would be a good example to go through writing a function that uses Generators, Each singleton function, and error handling all inside a custom function. Through this post you will also learn;

how to create Custom Function
how to use Generators as loop structure
and how to user Error Handling.

[…]