Forum Discussion
Power BI query
This is my query... (the problem is I need to combine CUSTOMERACCOUNT numbers beginning in 90, 900 or 9 with it's matching account 880, 34 or 1178 but dropping the 90, 900 or 9. I tried using replace...
Make sure that the CUSTOMERACCOUNT column is type text, then try typing this into the formula bar:
Table.TransformColumns(PriorStepName, {{"CUSTOMERACCOUNT", each Text.Range(_, 0, 2)}})
--Nate
Thank you for trying. But when I go to that column, it is filtered and shows
= Table.SelectRows(#"Filtered Rows4", each ([CUSTOMERCLASS] = "DS") and ([COMPANYNUM] = "01"))
I did try adding it but nothing worked. Thanks.
Tracy