Select a result to preview

REPLACE VALUES, MULTIPLE CRITERIA

#Power_query #Data

BI and PQ DATA TIPS AND TRICKS

https://gorilla.bi/power-query/replace-values/

= Table.ReplaceValue(#"Added Custom",
each [Amount],
//each if [ConditionTrue] = "YES" then 0 else [Amount],
each if [id] = 1 and [First Name] = "joe" then 0 else [Amount],
Replacer.ReplaceValue,{"Amount"})