Forum Discussion
dreyz64
6 years agoHelper III
Getting a slicer filtered value into a custom column
Hello everyone, I am trying to create filters based on a slicer. I have a table of sales and I have created a separate table with conditions on the years. The way I would like my re...
v-chuncz-msft
6 years agoCommunity Support
Values in a calculated column are fixed. But you may use ADDCOLUMNS in a measure.
https://www.sqlbi.com/articles/naming-temporary-columns-in-dax/
dreyz64
6 years agoHelper III
v-chuncz-msft Thank you for your answer, this indeed would be a bit better than creating so many new columns.
In the end, I bypassed the issue by using additional tables to filter the dates. Like this this I use one single volume column.