Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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 entities (companies) in Microsoft Dynamics Navision with above code (Company1 as an example).
Trying to add a custom column with an unique identifier based on the name of the company.
G_L Account number G_L Account name Amount Company 10010 Revenue 100 Company1 22000 Rent 50 Company1
Is it possible to achieve this by M code? My goal is to then append multiple tables from NAV with a column that specifies the source.
Many thanks.
Solved! Go to Solution.
@dinovic,
How about adding a conditional column or adding a custom column with if statement?
Regards,
Lydia
@dinovic,
How about adding a conditional column or adding a custom column with if statement?
Regards,
Lydia
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
29 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
53 | |
27 | |
15 | |
14 | |
13 |