Forum Discussion
How do I append two sources in DAX code instead of the append button?
Hi All, I have two JSON sources. Normally I would have to create two seperate JSON sources and append the 2nd to the first. Can someone write me out the code to do it all in one? Thanks! ...
It looks like your source step returns a record, so you can combine Source1 and Source2 like this:
CombineRecords = Record.Combine ( { Source1, Source2 } ),
#"Converted to Table" = Table.FromRecords ( CombineRecords )
Tried this, only gives me the second record