Forum Discussion

dinovic's avatar
dinovic
Frequent Visitor
8 years ago
Solved

Add a custom column based on source - Power Query / Dynamics NAV

let Source = Sql.Databases("xx.x.x.x"), zzz_LIVE = Source{[Name="NAVzzz_LIVE"]}[Data], #"COMPANY1$G_L Entry" = NAVzzzLIVE{[Schema="dbo",Item="COMPANY1$G_L Entry"]}[Data], Pulling data from several e...
  • Anonymous's avatar
    Anonymous
    8 years ago

    dinovic,

    How about adding a conditional column  or adding a custom column with if statement?



    Regards,
    Lydia