Forum Discussion
Combining Multiple Sum 'Value Sets' into One Column
Hi jrolson113
You can use union() and selectcolumn() function to create a new table to conbine three columns:
e.g:
Table 2 = UNION(SELECTCOLUMNS('Table',"a",[AMOUNT]),SELECTCOLUMNS('Table (2)',"b",[Amount b]),SELECTCOLUMNS('Table (3)',"c",[Ledger]))Please refer to the following links to know more about two functions:
SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn
UNION function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi jrolson113
You can use union() and selectcolumn() function to create a new table to conbine three columns:
e.g:
Table 2 = UNION(SELECTCOLUMNS('Table',"a",[AMOUNT]),SELECTCOLUMNS('Table (2)',"b",[Amount b]),SELECTCOLUMNS('Table (3)',"c",[Ledger]))
Please refer to the following links to know more about two functions:
SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn
UNION function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly