Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Formula issue: PowerBi Desktop New column vs PowerBi Desktop Power Query Editor new Custom Column

Hi,   I have a formula which I am able to apply as a new column in the PowerBi Desktop table itself but when I am trying to do the same in the Power Query Editor as a custom column, then I can't ge...
Need Help
johnt75's avatar
johnt75
Super User
3 years ago

Try changing all instances of [#"Pick&Pack_Total"] with [Pick&Pack_Total]

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi johnt75 

I have tried the change but without change/success. The Error seems to be in the first row.

 

  • johnt75's avatar
    johnt75
    Super User
    3 years ago

    That's the DAX syntax, the power query syntax is

    if condition then result1 else result2