I am familiar with adding multiple columns at one time, creating a "record." For example:
AddCustom = Table.AddColumn(Filter, "Custom", each [Test1 = [Sales]-[Expenses], Test2=[Expenses]-[Sales]])
This is going to give me a column to expand the "record" creating two new columns, Test1 and Test2.
Does anyone know if this can be done using the Table.AddRankColumn where I could be able to rank multiple columns in one step? Say I wanted to rank each of the Sales and Expenses columns but only use one step. I was thinking I was on the right track with above but cannot get to work.
I don't think so. You can add one rank column that ranks on both of those columns, but not two separate ranking columns in one operation.
I wondered as all my attempts were failing. I appreciate the reply and letting me know. Thank you.
