Forum Discussion

dreyz64's avatar
dreyz64
Icon for Helper III rankHelper III
6 years ago

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 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!

4 Replies