Add Columns Union

[Anonymous]

Hi,

I would like to add month (highlighed in Red) into my table if possible within the existing logic (highlighted in Black), any idea how I would I go about doing this please?

I have tried to copy the logic down, but can't get the syntax to work, or, my months and year column append rather than having 1 column for year and another for month. 

Volumes = ADDCOLUMNS(ADDCOLUMNS(DISTINCT(UNION(
SELECTCOLUMNS(VALUES(Mort[Mort_Year]),"Year",Mort[Mort_Year]),

SELECTCOLUMNS(VALUES(Comp[Comp_year]),"Year",Comp[Comp_year]))),

SELECTCOLUMNS(VALUES(Mort[Mort_month]),"month",Mort[Mort_month]),

SELECTCOLUMNS(VALUES(Comp[Comp_month]),"month",Comp[Comp_month))),

"Mort_vol",SUMX(FILTER(Mort,Mort[Mort_Year]=EARLIER([Year])),Mort[Mort_Count])),

"Comp_vol",SUMX(FILTER(Comp,Comp[Comp_year]=EARLIER([Year])),Comp[Mort_Count]))

"Mort_vol",SUMX(FILTER(Mort,Mort[Mort_month]=EARLIER([month])),Mort[Mort_Count])),

"Comp_vol",SUMX(FILTER(Comp,Comp[Comp_month]=EARLIER([month)),Comp[Mort_Count]))

This is how I would like my table to output. Any help on this would be much appreciate, thank you. 

@smpa01 

[v-xiaotang]

Hi @Anonymous 

Not sure what's your Mort & Comp table (data, structure, table relationship), it seems that you can try UNION(), SELECTCOLUMNS(), RELATED() function.

See the tutorial for how to use it, 

1. RELATED()

2. UNION()

3. SELECTCOLUMNS()

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.