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.
Oh yeah--in the Replave Values GUI dialogue, you have to check "Match Entire Cell Contents", or it will replace spaces anywhere there is one, as opposeds to the whole cell being "empty". Sorry about that!!
--Nate
You can indeed!
FixedColumn = Table.TransformColumns(Prior Step, {{"ColumnName", Text.BeforeDelimiter(_, "(")}})
--Nate
Oh yeah--in the Replave Values GUI dialogue, you have to check "Match Entire Cell Contents", or it will replace spaces anywhere there is one, as opposeds to the whole cell being "empty". Sorry about that!!
--Nate
Right in that screenshot, uncheck "Select All", select that "blank" value. Next, just right click on whatever that value is, right in the table, and select "Replace Values". Replace it with whatever you'd like.
Now just go the the applied steps, and delete the previous step to this one.
That's all!
--Nate
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |