Replacing just 1 value in a table.

This can easily be done in M.  In your query, add a custom column which looks for both the zero and an ID which identifies the row.

consumo_New = if ( [ID] = "whatever id" and [consumo] = "0" ) then "8770" else [consumo]

Remove the original [consumo] column and rename [consumo_New] to [consumo]

Later, you can update this column for any additonal updates you need to make

Hi bolabuga,

BraneyBI’s solution seems great, you can also use dax formula to replace the specify value(need a unique value to find the specify record):

For example( assume HIDRO is the unique value column):

Table = SELECTCOLUMNS(Sheet1,"Column1",[column1],"consumo",if(AND([HIDRO]=”Y09F266296”,[consumo]=0),8770,[consumo]),"Column2",[column2], "Column3",[column3],…)

Reference:

SELECTCOLUMNS Function (DAX)

Notice: dax query can’t replace current table’s value, you can create a new table to store these values.

Regards,

Xiaoxin Sheng