Forum Discussion

PedroAliança's avatar
PedroAliança
Frequent Visitor
3 years ago
Solved

custom column to compare standard

Hello, everone.  I use a lot of DAX to handle data and I'm gradually migrating to M.  This time I'm trying to format all clients that start with the first 10 digits of the CNPJ with the same na...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

PedroAliança's avatar
PedroAliança
Frequent Visitor
3 years ago

Can sameone help me?

 

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    3 years ago

    I suggest you post a usable example of data (either as text which can be copy/pasted or as a link to an uploaded workbook) as well as an example (could be a screenshot), of the results you expect from that same data. Obscure any confidential information, but ensure the data is representative.