Getting a slicer filtered value into a custom column

[dreyz64]

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 report to work is:

If 'Show reliable YTD data' is selected, then I want to filter everything which belongs to this year and who's month is 2 months before today. Example: today the report would show all volumes for 2020 from Jan to March.

If 'Show all YTD data' is selected, then I want to filter everything which is not in 2020.

If 'Show all YTD data and Previous year' is selected, then I want to show everything from 2020 and 2019.

I would like to create a custom column in my Main table which would put 1 on each line that fulfills the above selected condition. Like this I can sum up the volume based only on the periods I want to consider.

Then the aim would be that I create a measure that sums volume for every line where Custom col = 1.

Like this I can capture the sales corresponding to the periods I want filtered.

If you have a better approach do not hesitate to show me and thanks for the help!

[amitchandak]

@dreyz64 , did not get it completely, but refer if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[dreyz64]

@amitchandak 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]

@dreyz64 

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]

@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.