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 a novice with Powery Query, See below formula that works, although I need to continue to replace multiple numbers with "1.5"
Regards Colin
Solved! Go to Solution.
@ColinCowan Just how many numbers do you need to replace?
Greg, thanks cira 8 numbers
Colin
@ColinCowan I would just right-click your column iwith the numbers in Power Query Editor and do a Replace Values... step. Repeat 7 more times.
Greg I am unsure how to repeat the formula/action more than once.
@ColinCowan I wasn't talking about creating a new column. Just right-click the column header of the column in your table. Choose Replace Value... Enter the number to replace and the replacement. Click OK, that will add a step to your query. Right-click the header of that same column again, rinse and repeat.
Greg, thanks did not realize that it was that easy
Colin
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.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |