About Koen Verbeeck Koen Verbeeck is a Microsoft Business Intelligence consultant at element61, helping clients to get insight in their data. Then in the main SQL-based Query I would Merge with that new "Values" query, and set the Join Kind = Inner. Some background to the code List. In Power Query there is no tool yet for matching regular expressions (patterns). GitHub Gist: instantly share code, notes, and snippets. Which looks better to you? Power Query or VLOOKUP?. An ordered list of values. Looking up column names. (I could enter any two digits between the. Standard Trim. For example:. I also spent some time to do some special formatting like 1000 separator or dollar sign directly in Power Query, but, it seems Power Query team in Microsoft didn't consider formatting as a priority yet. Power Query: How to iterate over a list. You'll learn Power Query from the best in the business, My original text said that the parameter list was a likeness to an anonymous function, but that the. ToList(text as text) as list About. The problem that often occurs when doing this is that there are often dozens of pages or filters that need to be modified to get a full historical view of the data on the web page. It is my ambition to provide you with qualitatively appealing content. Pro Tip: In the Query tab, you can change whether the data loads to the data model or not by unchecking the 'enable load' option on the right-click menu for a query. During the training we looked at a scenario for one of the attendees where they needed to combine data from multiple Excel files into 1 big table. iqy; Open up Excel and enter a search term in Cell B3; Open the web query file you just saved (GoogleSearch. Next, you'll learn how to combine data from different sources. 3} this will give you a list in Power Query from 1 to 3. It replaces MS Query. Accumulate is quite a powerful function in Power Query, and I hope that be now I motivated you to seek for interesting new scenarios to explore it. You have seen or started using Power Query for Excel by now. JSON is built on two structures : A collection of name/value pairs. Combine({"Seattle", "WA"}) "SeattleWA" Example 2. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. Power Query – source reference as filepath in cell This short tutorial describes the Power Query (Get and Transform) connection to a file, whose name and path is written in a specific cell. Here’s the complete query. Then replace it with custom function – PowerTrim. It is a pain to write custom M code. Shortly – change. ToList(text as text) as list About. This page is a work in progress and will continue to be updated. You can think of an ETL tool built into your familiar Excel. It displays the categories of M functions, and would be a good page to bookmark for quick reference. Power Query Concatenate Data using ‘M’ Language. The global environment. I had to figure out recently how to load multiple JSON files using Power Query. Transform is one of the most versatile functions that you can use on countless occasions. If not you have been missing one of the greatest tools of the new Self-Service Business Intelligence offering Power BI. This is the first of two related posts that demonstrate how to use Power Query to deal with rows and delimited lists. This post will look at two different approaches for expanding a record from a list using Power BI and a bit of M syntax. How to join tables with Excel Power Query. Learn how to write a Power Query formula for converts dates to text. The GUI doesn't implemented all functionality of M. Microsoft Power Query for Excel, is a new add-in that provides a seamless experience for data discovery, data transformation and enrichment for Information Workers, BI professionals and other Excel users. No problem for Power Query as the master of transformations: We just temporarily transform our text into a list, perform the replacements and then transform our list back into text – as if nothing has happened 🙂 Text. What formula bar?. Extending the PowerQuery date table generator to include ISO Weeks. But, as soon as I refreshed the data source from Power Query all of the defined formatting were gone. In Power BI / Power Query, whenever you want to replace a text string inside of a column, you need to do it one at a time. Power Query: Creating a parameterized function in M This will be part two in my on-going series about Power BI, Power Query, and the general joys of data. For a bit of fun, we're going to look at information held in the Science Fiction Awards Database This is a wonderful resources that records the nominees and winners for every…. Access one of the pages of data on the site using Power Query's From Web functionality. Business Apps Developers using PowerApps can now use the Power Query feature to create new entities and then load data into the Common Data Service based on data from a wide range of external data sources, including on-prem data sources such as relational databases (SQL Server, IBM DB2, etc. Renaming Dataset Columns. Power Query is a deep and powerful tool that lives inside of Excel. In Power Query, I have a column which contains "List" values. There are number. Split(text, " ") will split out text strings into a list of single words because we choose blank as the delimiter. Posted in Julie, Power BI, Power Query Tagged Power Query, Power Query - convert list to table, Power Query Creating functions, Power Query Error-- Expression. What formula bar?. Just like the text to column option, we have "Split Column" in power query. Even with setting up locale and. For any changes in the source data sheet, one just has to go to Data > Refresh All For any changes in the source data sheet, one just has to go to Data > Refresh All. However when I create a new item in the Sharepoint list itself, the values are correctly displayed as multiline. By default, Power Query promotes only text and number values. MS Query Cons: Microsoft Query falls short of the Power Query AddIn in some other aspects however: Power Query has a more convenient user interface. Use VBA to automate Power Query in Excel 2016 Are you familiar with Power Query for Excel 2010 & 2013? In Excel 2016 you can now use Macro Recording and Object Model (VBA, PowerShell, C# etc. Retrieve, Transform, and Combine Data Using Power Query. In Access it'd be "REF" & format([field],"00000"). With text files, you can place them all in one folder to form a database. This helps when your data contains cells or rows with blank (null) values, and you want to copy down the value from the cell above. If you've been using Power BI or you've seen the demos, then like me, you're probably excited about Power Query. Advanced Editor Feature Image. I had to figure out recently how to load multiple JSON files using Power Query. I am trying to load a JSON file I pulled from data. #PowerQuery - Filter a table based on another table column or list - and some Filter aha's One of my favourite features in Excel and Power BI is Power Query / M - and I just wanted to share a small trick when you want to filter a table on specific items. In the above picture, you can see that the Column Headers (Field Names) have the un-. Next, you will create a another query to combine the data from the two tables. We can read an Excel table into Power Query, let Power Query append the imported data, and then write the data back to Excel. You are now probably wondering what "list" function even means in Power Query. This post will look at two different approaches for expanding a record from a list using Power BI and a bit of M syntax. Contains(), and then filter the list. I hope you have found this power query tip useful, but now, tell me one thing. In our specific case, a customer wanted to pull data from a record that was listed in the table output of a SharePoint list. Accumulate is a function that can easily save a number of steps in your Power Query transformations, instead of applying multiple steps, you can simply use List. Trim operation is a standard text transformation. Insert Inserts a specified value at a given position into a given text field. Are your codes the actual values that you want to group by, because you can do "Group By" in your Power Query or is there some other grouping. Now, configure the "Query String Filter" Web Part by clicking the "Open the tool pane". Take Power Query to the next level: share your queries and create a corporate data catalog. Access one of the pages of data on the site using Power Query's From Web functionality. Attached file is part of a larger table with the following column names: , , , , The first step works on values in. When you rename columns manually, auto-generated function looks like. This can be used when you needs to simply control, which file is used as source, without even opening Power Query. Having this capability is very handy if you have files reporting on the same info (say sales figures) from different regions or multiple periods. For the Power BI API we need an authentication module. So in theory, based on the condition only the "THEN" block or the "ELSE" block would be executed. In my last post I outlined how to iterate over a list in Power Query. Join Oz du Soleil for an in-depth discussion in this video, Split text in Power Query: Split real-world data fields, part of Excel: You Can Do This. We can read an Excel table into Power Query, let Power Query append the imported data, and then write the data back to Excel. I would first build a Power Query e. How to query data from SharePoint Online list in Excel I am trying to import data into Excel from a list on SharePoint Online. Generate to. Is there a more direct way to transform the type of the elements in a list than via Table. I have a table of data which includes employees' full names, but a few spaces have been added along the way so that they are no longer nicely aligned:. In order to use Power Query, it firstly needs to convert the data to a structured reference table. Otherwise, you have the options of choosing the data from csv files or other sources. To manually add the Load query, click 'From Other Sources' in the Power Query ribbon tab, select 'Blank Query' (bottom option), open the Advanced Editor in the View tab, and paste in the below snippet (after adjusting file path). In the top ribbon, you can see the list of Web Parts available to add in the page. For a bit of fun, we're going to look at information held in the Science Fiction Awards Database This is a wonderful resources that records the nominees and winners for every…. As directly querying SharePoint content databases is not supported by Microsoft and it also could cause performance issues to your SharePoint farm - Lets not think about it further!. Power query has inbuilt time intelligence capability to convert dates to quarters. Re: power query error: we cannot apply operator - to types text and number nevermind, i ended up figuring it out. The global environment. Repeat this process for each table -- text file -- you want to add. (I could enter any two digits between the. The aggregation formula needs to be able to handle a list as variable. Power Query can be used to get a list of file names from a folder or sub-folders in it. Power Query creates and adds the needed transformation steps to your query! You have the power. 8/2/2019; 2 minutes to read; In this article Syntax Text. It is just an outstanding all-around player that you probably would start incorporating into your query once you find out how good it works in many situations. In this example, I set the data type of the first column as Date by following the process I describe further below. Power Query (PQ) is now THE tool for importing data into Excel. On the Power Query tab select From File and then From Folder. In this Post. Combine joins the selected words back to “text” by using space. Happy Querying! Dear readers, I write my articles for you. Posted in Julie, Power BI, Power Query Tagged Power Query, Power Query - convert list to table, Power Query Creating functions, Power Query Error-- Expression. Access one of the pages of data on the site using Power Query's From Web functionality. In this example, I set the data type of the first column as Date by following the process I describe further below. ), and easily reconfigure the data into a pivot table in a spreadsheet. Another scenario where List. List of PowerPivot DAX functions with description (date_text) Converts a date in the form of text to a date in datetime format Returns e raised to the power. Power Query: Check if Field contains text from list I am not familiar with PQ enough to understand what I am doing wrong, but I think I am in the ballpark. Power Query for Excel: Load Settings Minimize Wasted Memory Here at AKA Green Beacon, we are excited about helping our customers leverage Power BI. A relatively new feature of Power Query that helps you concatenate, merge or combine multiple rows of data into a single value with just a few clicks. Let's Create a Web Query. Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. Hi All, I've imported a number of excel sheets into a Power Query Table. This is likely not a common requirement for most Power Query users, but I saw this requirement in the Twitter API and thought it would be a fun challenge in M. I have fields on the list that are of the User/Group type. M is a powerful language, and the good news is that M is much more powerful than what you see in the Excel GUI of Power Query. If we glance at the Query Setting under the Applied Steps, we now have 4 steps. Generate() - Tips and producing a Date Range Search for: Search. This is possible with Power Query’s formula language, which is called M. Posted in Julie, Power BI, Power Query Tagged Power Query, Power Query - convert list to table, Power Query Creating functions, Power Query Error-- Expression. From(_[name])), ",")}), This is throwing the following error: Expression. There are a couple of subtleties to querying SharePoint list items with Power Query, and I will briefly walk through the process below. If your data is already present in the Excel file, you need to select “From Table”. Using Power Query, you can import, reshape, and cleanse any data from a simple interface, so you can mine that data for all of its hidden insights. Obtain a Text Analytics API Key from Microsoft Cognitive Services. What formula bar?. Change Column Type to Whole Number. When searching the Power Query formula reference you may stumble upon the formula Text. The article is geared to explaining five functions specific to working with Text in Excel, and are a set of the most under-utilized functions in Excel (in my opinion). ToList("Hello World"). Can we also throw some other crap? I mean I want to use it to do more things that I thought I could never be able to do, using Power Query. In the list of available add-ins, select Power Query and click OK. Now, configure the "Query String Filter" Web Part by clicking the "Open the tool pane". While Power Queries are relatively easy to create, the MS Query Wizard is like a website from the 90's; Power Query stacks operations on top of each other allowing more convenient changes. This week I was challenged to find a way for one of our customers to view how many customers they have by zip code, and compare it to the population within the area so that they can determine if they should accept new customer requests. This list value is then converted to a table value with a single column (Second) and a new column ( “TimeDuration”) is added of the duration type based on this Second column. Returns a list of character values from the given text value text. • ehind the Power Query solution is a “Function ased” ase Sensitive omputer Language called M Code. If you click on the down arrow on the right-side of the text box, a list of values is displayed similar to the standard Power BI slicer drop down list. I'm trying to import a text file into Excel but having problems with delimiters. From every keyword, pull the 2nd word. If you already have my Power Query editor for Notepad++ (or want to build it) you can open the file in Notepad++. You can copy this code snippet and create a new Blank Query from the Other Sources drop-down. Setting up the Parameter. Otherwise, seems like you would have to use the Text. Power Query – source reference as filepath in cell This short tutorial describes the Power Query (Get and Transform) connection to a file, whose name and path is written in a specific cell. This list value is then converted to a table value with a single column (Second) and a new column ( “TimeDuration”) is added of the duration type based on this Second column. Power Query: How to iterate over a list. Join Oz du Soleil for an in-depth discussion in this video, Split text in Power Query: Split real-world data fields, part of Excel: You Can Do This. Otherwise open it in a simple text editor and paste it into the Advanced Editor of Power Query or Power BI Desktop. Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. The GUI doesn't implemented all functionality of M. Power Query for Excel: Load Settings Minimize Wasted Memory Here at AKA Green Beacon, we are excited about helping our customers leverage Power BI. • Use Power Query to create data sources, data models, finished reports, parameters for other queries and it can help replace complex Excel array formula solutions. how can I CONVERT this list to text, thank you very much Solved! Go to Solution. Imagine that you have 10 replacements that you need to do, that'll translate into 10 times that you'll have to click on the "Replace values" button and go through the configuration menu:. It discusses working with using Power BI to report on rich text fields from SharePoint. In simple terms, Power Query (also known as Get & Transform in Excel 2016 and Excel 2019) is a tool to combine, clean and transform data from multiple sources into the format you need such as a table, pivot table or pivot chart. But when I fill out the form and submit it, the values of the multiline text fields are displayed as a single line in the Sharepoint list. Power Query is available as an add-in to download and install for Excel 2010 and 2013 and will appear as a new tab in the ribbon labelled Power Query. For example, if we want to use the Excel’s FIND Function to find a specific character in text , it is not supported in M. For all other types of statements, the return value is -1. A complete list of all our Power Query blogs can be found here. Answer Wiki. I have a table of data which includes employees' full names, but a few spaces have been added along the way so that they are no longer nicely aligned:. Trim operation is a standard text transformation. I also spent some time to do some special formatting like 1000 separator or dollar sign directly in Power Query, but, it seems Power Query team in Microsoft didn't consider formatting as a priority yet. In the list of available add-ins, select Power Query and click OK. Transform text with exceptions in Power BI and Power Query Recently I picked up an interesting request to transform text with exceptions: Transform the words in a column to proper case, but keep certain keywords like in a defined list. As we saw in a previous post, there are many things that we need to consider when dealing with Excel files since even the extension of an Excel file can dramatically impact your solution and how Power Query interprets the contents of that file. Power Query will preserve worksheet customizations such as Data Bars, Color Scales, Icon Sets or other value-based rules across refresh operations and after query edits. Is there a more direct way to transform the type of the elements in a list than via Table. Now what we want is to pivot particular column so that it each particular shows in individual column as headers with info items as content. It is powerful an easy to use. See how to create a unique sorted list with Power Query. The sample here has two power queries connecting to SQL server source. From(_),"#(lf)"," ")) renamedTable = Table. Power Query can perform operations relevant to text when grouping data. In this article, we will learn about the text. Hopefully, you already know this, but Power Query's library includes a number of functions related to type text. Editor’s note: The following post was written by SQL Server MVP Rafael Salas Creating Power Query Functions. For example, I have a field called Requested By that is a User/Group field. instructs Power Query to fill in the blanks. Updated: July 22 2018. Then in the main SQL-based Query I would Merge with that new "Values" query, and set the Join Kind = Inner. @srutt Why do you need the list of dates? In any case, you can simply right click the table column's header and select "Drill Into", that should give you the column as a list. If not you have been missing one of the greatest tools of the new Self-Service Business Intelligence offering Power BI. This can be done with the help of Power Query CONCATENATE formula. I did this in NotePad++, a free but powerful utility. Creating the initial query. Combine(List. A dialogue box will appear that will change your data range to table if its not already a table. From Web actually generates two separate M functions - Web. JSON is built on two structures : A collection of name/value pairs. We used a solution provided by Matthew Stark who initially had a very good solution to use with Excel Power Query and Power Bi Desktop utilizing Odata. How to combine multiple tables with Excel Power Query. Using Power BI to Visualize Customer Saturation. GitHub Gist: instantly share code, notes, and snippets. I am in the process of finalising some action items after a great Power BI, Power Pivot and Power Query training course in Melbourne. Power Query (aka Get & Transform) has a Fill function that allows us to fill cells with the value above or below. Instead of manually rearranging data and repeating the process, Power Query lets you build a set of steps that you can apply to your data repeatedly. If you want to get random sample with Excel formulas, read this. ExpandRecordColumn (table, text, list, [list?]) Table: 指定した列の Record の値を展開し、複数. Power Query is embedded in Excel, Power BI, and other Microsoft products, and leading Power Query expert Gil Raviv will help you make the most of it. First: I changed my blog and created THE SELF-SERVICE-BI BLOG. Check out Power Query Top 10 Tips & Tricks. I would first build a Power Query e. Ability to use wildcards in power query transformation find section of replace values. Power Query is an Excel add-in that can be used for data discovery, reshaping the data and combining data coming from different sources. JSON is built on two structures : A collection of name/value pairs. This is possible with Power Query's programming language, which is M. Whilst the source was still text I noticed. and that object can be simple structure object such as Date, Text, Number. In power query, all you have do is to create the connection for tables and merge the queries. Hopefully this is something that Microsoft will address in future versions, as the Power BI products become more integrated with Dynamics CRM (like the recently announced CRM Online connector in Power Query). Learn how to write a Power Query formula for converts dates to text. Click on the ABC123 icon and select Whole Number. It is just an outstanding all-around player that you probably would start incorporating into your query once you find out how good it works in many situations. Then replace it with custom function - PowerTrim. ExpandRecordColumn (table, text, list, [list?]) Table: 指定した列の Record の値を展開し、複数. Depending on the version of Excel that you have, the Get & Transform group looks different. Download the sample workbook. Learn Power Query with this easy to follow online video training. Converting Lists Of Numbers To Text Ranges In Power Query November 24, 2016 By Chris Webb in Uncategorized 13 Comments In a comment on my post on Creating Sequences of Integers And Characters In Power BI/Power Query Lists a reader, Paul G, asked me the following question:. However, I would like to keep this transformation with many others in Power Query. To remove unnecessary chars from string in Power Query. Unfortunately, at least as of the present, regular expression support isn't a part of that list of functions. Open the Shape List query that was created earlier and add a custom column: This will add a new column which calls the custom function. In the above picture, you can see that the Column Headers (Field Names) have the un-. Hopefully this is something that Microsoft will address in future versions, as the Power BI products become more integrated with Dynamics CRM (like the recently announced CRM Online connector in Power Query). One of them are folders, which retrieve basic information about files (e. The Power Query Advanced Editor comes without intellisense (auto completion), no parameter hints, no syntax highlighting, no help texts, which explain what the functions do, no nothing. This way I could create a Power Query/Power Pivot solution in Excel, refresh it on a timely fashion by an admin with access to the source data and then just publish that SNAPSHOT of data for consumption in Power BI through OneDrive for example and be able to refresh THAT FILE’s data only so it reflects changes I make in the Excel file. Accumulate function take three parameters. Unfortunately not all of Excel's formulas can be used in M. Ability to use wildcards in power query transformation find section of replace values. In Power Query there is no tool yet for matching regular expressions (patterns). Writing Custom Functions in Power Query M Reza Rad's Technical blog. At the right, you can see a list of queries, with a Refresh button at the right side of each query. In this example, I set the data type of the first column as Date by following the process I describe further below. The points are: 1) Define each table in the workbook as a named range (I assume they are in the same workbook). Please take a minute and give me a review or comment below. Transform(Table. Whilst the source was still text I noticed. This can be done with the help of Power Query CONCATENATE formula. Returns the result of combining the list of text values, texts, into a single text value. It replaces MS Query. Splits column to multiple columns, using delimiter or fixed number of characters. upper(string as nullable text) as nullable text. I have a table of data which includes employees' full names, but a few spaces have been added along the way so that they are no longer nicely aligned:. Please select the Split Columns and then select By Number of Characters option. A formula that both combines text and takes a list as input. Setting up the Custom function Query(with code to copy) Grouping the text. ToText(current), each null, type text ) ) Let’s go one by one to figure out what this trick does. To demonstrate this Power BI split columns option, we are going to use the Text Employee table that we imported in Enter Data article. Make a list of numbers in a jiffy with Power Query: We know that in Excel, you can type a few numbers and use the fill handle to fill down (or up etc. Extending the PowerQuery date table generator to include ISO Weeks. As we saw in a previous post, there are many things that we need to consider when dealing with Excel files since even the extension of an Excel file can dramatically impact your solution and how Power Query interprets the contents of that file. Shortly - change. In our practice, often times we'll include dates and text in a description (09/13/17 SPED, 1-15-09 AUDIO). Power Query has the ability to do some basic "screen scraping" of data from web pages and add this as a new data source to your Self-Service BI solution. Having this capability is very handy if you have files reporting on the same info (say sales figures) from different regions or multiple periods. Smart Filter as an Observer The third setting (#3 above) allows you to use a Smart Filter as an Observer. What formula bar?. This wikiHow teaches you how to use the Power Query feature in Excel 2016 on a Windows and Mac computer. In Access it'd be "REF" & format([field],"00000"). Whenever you do a data query in Excel 2019 using the Get Data, From Text/CSV, From web, or From Table/Range command buttons on the Ribbon's Data tab, you have the option of transforming that query in the Power Query Editor. Pivot data using Power Query to show text values – Data Restructuring using Excel – How To. As far as I am concerned, the weakest part of the Power Query is the iteration. Select Power Query and press OK. Range function. Now the column data type has changed to numbers only. Learn how to convert dates in Excel Power Query/Get & Transform using the Add Column or the Transform technique. If not you have been missing one of the greatest tools of the new Self-Service Business Intelligence offering Power BI. Dates), the algorythm (and rules) of creation of successive element could be virtually any. There's not a visual indication in Power Query on steps after a filter operation has occurred, so keep an eye out for that if you are doing some data exploration as you build your steps. In the ‘Excel Options’ dialog box, click on Add-in in the left pane. One of the most common tasks of Power Query is to set up automated data refresh from multiple sources. JSON is built on two structures : A collection of name/value pairs. However, I would like to keep this transformation with many others in Power Query. AddColumn( state, "Col" & Number. Text modifications with Power Query (Get and Transform) This tutorial describes modifications, that can be done with Text in Power Query (from Excel 2016 called Get and Transform). The expression's results are assigned to the PromoteNames variable. Power Query is an Excel function that allows you to import data from a variety of sources (Excel tables, CSV files, online database, etc. ToList("Hello World"). No problem for Power Query as the master of transformations: We just temporarily transform our text into a list, perform the replacements and then transform our list back into text – as if nothing has happened 🙂 Text. Power Query has been around since Excel 2013 2. Details: 1. Power Query lets you perform a series of steps to clean & transform your Excel data. I got the original Power Query function from Ken Puls blog post Clean WhiteSpace in PowerQuery which he does a great job of removing leading, trailing or multiple spaces within text. Updated: July 22 2018. Power BI and Excel offer a wide variety of collaboration and sharing experiences. Execute() the Swiss Army knife of Power Query 2017-03-11 Power Query M , Power Query , R hugoberry I rarely use R in Power BI, but when I do, I make sure to keep the data mashup out of it. Finally, you'll learn how to share the queries you've created. You are now probably wondering what "list" function even means in Power Query. This article covers. Access one of the pages of data on the site using Power Query's From Web functionality. An ordered list of values. That’s all the prerequisites we need to run the Azure AD commands. The Power Query (M) Builder is a new tool for the XrmToolBox. I can find how to add a Prefix from the format dropdown which sorts the REF part but not the bit that transforms numbers into 00000 format. A complete list of all our Power Query blogs can be found here. This can be used when you needs to simply control, which file is used as source, without even opening Power Query. Even with setting up locale and. let //Capture the date range from the parameters StartDate = # date ( 2015 , 01 , 01 ), EndDate = # date ( 2099 , 12 , 30 ), CurrentFinancialYear = if Date. This helps when your data contains cells or rows with blank (null) values, and you want to copy down the value from the cell above. Power Query was designed so that you do NOT have to know how to code to use it. This post will look at two different approaches for expanding a record from a list using Power BI and a bit of M syntax. Most users know the Group By function in Power Query. All mentioned buttons can be found in Trasform / Text Column. Here’s how you do it with Get data from folder command in Power Query. Today I had a table where the column contained information about both the parent element and child element In the example the CategoryInfo column contains both the Category and sub Category information. One of the unique characteristics of M is it takes data. Combine(texts as list, optional separator as nullable text) as text About.