Forum Discussion

SwathiGanesh's avatar
SwathiGanesh
Frequent Visitor
3 years ago

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...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
3 years ago

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.

Håkon's avatar
Håkon
Icon for Advocate II rankAdvocate II
3 years ago

Jeg setter stor pris på hjelpen!