Forum Discussion
Combining Multiple Sum 'Value Sets' into One Column
Hi All,
I'm relatively new to the PowerBI-verse, so please bear with me if I'm missing something basic. I am trying to build a report that incorporates a few different data sets into one.
As you can see, there are 3 columns on this report, as I am pulling from 3 data sets.
These are the three 'Value Sets' I have currently.
I am looking for way to combine those three sets so it only shows up in one column, instead of the 3 separate columns. I am looking to do this outside of the excel sheet, and my presumption is that I am missing something here to bring it all together.
Any advice would be greatly appreciated!
Thanks
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
1 Reply
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