I'm replacing values in Power query. I replaced the correct values with a formula that was created in excel, but now I see that Power query doesn't work like that:/
the idea is to replace the value "½" to get the values as in this picture
THE NON-WORKING FORMULA IS THIS:
= Table.ReplaceValue(#"Odstranjeni stolpci","½","=Value(INDIRECT(ADDRESS(ROW();COLUMN()+1))-0.5)",Replacer.ReplaceValue,{"Column1", "Column2", ..............
If someone can help me resolve this, it would help A LOT!
