Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am currently working on a sales table in PowerQuery which contains a list of 'Customer Numbers' as numerical values. Most of these are reoccuring customers with a single 'Customer Number' but there is an growing list of 'Customer Numbers' which are generated for one time sales.
These have an 8 digit format as opposed to the stadard vaiation of no more than 4 digits.
I want to replace all values in this table over say 7 digits or greater than 10000000 with a text frase of "Internal".
Can someone please help with a solution in PowerQuery.
Solved! Go to Solution.
Create a new conditional column as below.
If it helps, mark it as a solution
Kudos are nice too
Create a new conditional column as below.
If it helps, mark it as a solution
Kudos are nice too
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.