Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Creating a filter from multiple columns which overlap.

Hi all, 

 

I would like a date filter which would let me select from these four options;

 

Current Year to Date
Rolling 12 Months
Rolling 24 Months

Future Dates

 

I have a date dimension with 4 TRUE/FALSE columns for each of these to filter on, but I'm having issues as they overlap each other so for example rolling 24 months is only showing 13-24 months if selected. 

 

Is there any solution to this that doesn't use a SWITCH measure? We don't want to sacrifice performance in this large report and already switches through multiple measures.

 

Thanks

Need Help

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi Anonymous,

    You create a slicer including the four options. When you select "Rolling 12 Months", you want to display all the dates in the rolling 12 months, right? If it is, what's your sample table look like, could you please share it for further analysis? Or you use the slicer to filter measures like context in this article?

    Best Regards,
    Angelia