Forum Discussion
custom column to compare standard
Hi PedroAliança ,
You want the following calculations to be listed in Power Query, right?
Here's the solution in Power Query.
1.Add a custom column to return the first ten characters starting from the left.
2.Add an index column.
3.Group by the [LEFT10] and set up as follows.
4.Expand the All Rows column
5.Add a conditional column to compare.
6.Fill up the column.
7.Sort based on the index column and the [Custom] column is the result.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi PedroAliança ,
You want the following calculations to be listed in Power Query, right?
Here's the solution in Power Query.
1.Add a custom column to return the first ten characters starting from the left.
2.Add an index column.
3.Group by the [LEFT10] and set up as follows.
4.Expand the All Rows column
5.Add a conditional column to compare.
6.Fill up the column.
7.Sort based on the index column and the [Custom] column is the result.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good Morning!
It worked just fine. Thanks for the class!
