![]() This proves that even though text operations are not listed in the user interface, we can still edit the M code to achieve this outcome. We now have a list of salespeople for each customer. However, in the M code, we can change this: = Table.Group(#"Changed Type", ) When clicking OK, it generates an error in the Sales By column, as Sum cannot be performed on a text value. Apply the following parameters in the Group By dialog box: Let’s suggest we want a list of every person who sold to each customer. We just need to make a few edits to the generated M code. However, we can perform text aggregations too. In the operations list in the dialog box, there are only numeric transformations (Sum, Average, Min, etc.). While each column may contain duplicates, the combination of columns is unique. The table shows the unique items from the Product and Customer columns with the Sum and Count operators applied. ![]() In the new column name section, apply the following settings:Ĭlick the add aggregation button, then set the new column as follows Click the Add Grouping button to add columns, or the three dots ( … ) to remove columns. Set the first section to include the Product and Custom columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |