LmendesFrequent Visitor7 years agoSolvedReplace values Hello I am struggling with two things to do with replacing values. https://www.dropbox.com/s/0j792l4jlkfsigr/Replace%20values.pbix?dl=0 https://www.dropbox.com/s/vvedv43zubsptxh/Replace%20valu...Show Moreparry2k to Lmendes7 years agoLmendes solution is attached, check power query replace steps. Replace values (1).pbix50 KB
parry2k to Lmendes7 years agoLmendes solution is attached, check power query replace steps. Replace values (1).pbix50 KB
parry2k to Lmendes7 years agoLmendes solution is attached, check power query replace steps. Replace values (1).pbix50 KB
parry2kSuper User7 years agoLmendes solution is attached, check power query replace steps. Replace values (1).pbix50 KB
LmendesFrequent Visitor to parry2k7 years agoBrilliant thanks so much! Just a pointer for learners (like me). I had to include [Q3] as [#"Q3"] and [Q2] as [#"Q2"] etc.... for it to work. But it now works like a dream :)
Related contentReplacing values with IterationsReplace Errors values with Null valueshow to dynamically replace values for multiple columnsReplace multiple values at once (replace value)Replacing null values with blank
