Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

Power Query: Update Statement Equivalent (SQL)

Hi Community and M Gurus!   Is there an equivalent syntax in Power Query where I can update existing records via "update" command?    
Need Help
ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

Hi GilbertQ & Anonymous,

 

I was actually referring to this (mysql) and an M/Power Query-equivalent

 

UPDATE [LOW_PRIORITY] [IGNORE] table_reference
    SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ...
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi ovetteabejuela,


Power bi not exist equivalent function of update. In my opinion,I think you can add a custom column which the if statements, then delete the original column.

 

Regards,

Xiaoxin Sheng