Forum Discussion
dreyz64
Helper III
6 years agoGetting 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...
dreyz64
Helper III
6 years agoamitchandak Thank you for the answer.
I basically want to filter my data based on criterias from a slicer.
But tbh creating new measures for every data is very inefficient... In Tableau a simple filter works...
v-chuncz-msft
Community Support
6 years ago
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/
- dreyz646 years ago
Helper 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.