calculated column doesnt follow queries when merging or appending

[db042190]

hi i have a sales query and a "spend" query.  It looked to me like i'd have to create a type (sales,spend) column in each so i could merge or append them if i want to show them both plotted in a multi line plot visual.  But when i went to merge/append them the type column isnt tagging along.  i believe neither is hidden.   do i have to add the type column way back in the queries themselves in order to circumvent this obstacle?

[ryan_mayu]

are you using DAX to create the columns?

i think you should use M to create column in the power query.

[db042190]

i'll try that and report back here.  seems like a weird decision all things considered.