Power query create list Generate function in Power Query. Combine the text of each row with a comma. In Power Query, transform the overall grant amount into a daily amount first, then use this sort of formula: = Table. Feb 25, 2016 · List. Combine the two simple lists {1, 2} and {3, 4}. Best Regards, Rico Zhou Apr 10, 2018 · Create a list in Power Query it's easy {[col1], [col2], [col3]) But how do you create a list when you have a variable number of columns ? Aug 11, 2017 · Hi all, I'm trying to create a column which contains all values between to numbers. StartOfMonth([COD])), x)) Apr 11, 2019 · I need to do something similar in a report I have. Dec 21, 2016 · Oustanding Maxim; pretty sure this will do! I am wanting to create a query that will automatically scan through (any) model tables/queries, ID "date" / "datetime" fields, determine MIN and MAX values and then feed those as parameter inputs into a query function that generates a dimCalendar table (FNdimCalendar) automatically. Examples Example #1 Create a list of 5 values starting from New Year's Eve (#date(2011, 12, 31)) incrementing by 1 day(#duration(1, 0, 0, 0)). Combine(lists as list) as list About. slqgmb oax qdnrldp ytgb bdun rjm ogwspki kimup bbgpx rxtt