Using Power Query to restructure Microsoft Excel data requires no expressions or functions. You add a column for the combined values and then group if you want to combine those values further into ...

Unlike Microsoft Excel, Microsoft Power BI doesn’t have the ability to build custom sorts. However, you can sort one column by another, which is effectively the same thing and easy to implement.