Forum Discussion
Anonymous
6 years agoNot applicable
Different Date slicer for Different Columns
Hi, I want to apply different date slicer for different column in my grid. eg: Here, I want to compare metric 1 (for a specified date range) to metric 2 (for a different specified...
PaulDBrown
Community Champion
6 years agoAnonymous
One way of doing it:
1) create a duplicate of your date table, with no relationship with your fact table
2) create measure for your metric 1
3) create a metric measure which filters your date table based on the selection in your second date table (Metric 2 Date table):
Metric 2 = CALCULATE(SUM('Fact Table'[Target]);
TREATAS(VALUES('Metric 2 Date Table'[Metric 2 Month-Year]);'Calendar'[Month-Year]))
and you get this: