Forum Discussion
ConnieMaldonado
Responsive Resident
Responsive ResidentChange a Field with CALCULATETABLE
I am using CALCULATETABLE to create a table from another table where category = "Split". Once I have this subset, I want to replace category with "Materials". Can I do this all in the same statemen...
Hi ConnieMaldonado ,
If you want to get a modified table directly, I recommend creating a new column in the original table first.
This is my test table:
Create a new column:
NewCategory = SUBSTITUTE('Table'[Category],"Split","Materials")Create a new table:
NewTable = FILTER(SELECTCOLUMNS('Table',"ID",'Table'[ID],"Category",'Table'[NewCategory]),[Category] = "Materials")Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yadongf-msft
Community Support
Community SupportHi ConnieMaldonado ,
If you want to get a modified table directly, I recommend creating a new column in the original table first.
This is my test table:
Create a new column:
NewCategory = SUBSTITUTE('Table'[Category],"Split","Materials")
Create a new table:
NewTable = FILTER(SELECTCOLUMNS('Table',"ID",'Table'[ID],"Category",'Table'[NewCategory]),[Category] = "Materials")
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.