Forum Discussion
Advanced Filter
How do I create a filter that has Jan,feb as well as This month, last fiscal year, as its elementn.
Note : This month, last fiscal year are not in dataset, has to be calculated and included as slicer elements.
Hi Abhijsrwala1 ,
The option in slicer must be the value in the column, so you should create a new table.
Slicer table = UNION ( VALUES ( 'Table'[Month] ), ROW ( "Month", "This month" ), ROW ( "Month", "Last fiscal year" ) )Get the result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Abhijsrwala1 , Based on what I got, You can have year behind measures
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Year))
Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))or last year same month
last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
Previous year Month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth(dateadd('Date'[Date],-11,MONTH)))
last year MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-12,MONTH))))amitchandak I understand, but once those values are calculated how to bring that under one slicer along with rest of the values. As you can see. 01-Jan and calculated values are together in one slicer.
Hi Abhijsrwala1 ,
The option in slicer must be the value in the column, so you should create a new table.
Slicer table = UNION ( VALUES ( 'Table'[Month] ), ROW ( "Month", "This month" ), ROW ( "Month", "Last fiscal year" ) )Get the result.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
