Forum Discussion
Need syntax help to summarize only the selected column
I have three columns in a table and we are using parameters to select the required column to the table. Based on the selected column, I need to summarize and do some calculation. I am stuck and un...
SwathiGanesh, you can use the UNION function to combine the data from both columns into a single table.
UnionTable =
UNION(
SELECTCOLUMNS(Table1, "Column1", [Column1], "Column2", BLANK()),
SELECTCOLUMNS(Table2, "Column1", BLANK(), "Column2", [Column2])
)
The SELECTCOLUMNS function is used to select the columns from each table that you want to include in the UnionTable.
Jeg setter stor pris på hjelpen!