Forum Discussion
maurcoll
Helper IV
5 months agoLooking at future orders based on date selection
Hi is it possible to have a date slicer and multiple tables on a page. Each table covers a months orders going forward. I want to be able to select a 3 month period in the future and have 3 tables on...
- 5 months ago
Step 1) Create month offset measures
Month 1 Start = MIN ( 'Date'[Date] ) Month 1 End = EOMONTH ( MIN ( 'Date'[Date] ), 0 ) Month 2 Start = EOMONTH ( MIN ( 'Date'[Date] ), 0 ) + 1 Month 2 End = EOMONTH ( MIN ( 'Date'[Date] ), 1 ) Month 3 Start = EOMONTH ( MIN ( 'Date'[Date] ), 1 ) + 1 Month 3 End = EOMONTH ( MIN ( 'Date'[Date] ), 2 )Step 2) Create a filter measure per table
Is Month 1 = IF ( MAX ( Orders[Date] ) >= [Month 1 Start] && MAX ( Orders[Date] ) <= [Month 1 End], 1, BLANK () ) Is Month 2 = IF ( MAX ( Orders[Date] ) >= [Month 2 Start] && MAX ( Orders[Date] ) <= [Month 2 End], 1, BLANK () ) Is Month 3 = IF ( MAX ( Orders[Date] ) >= [Month 3 Start] && MAX ( Orders[Date] ) <= [Month 3 End], 1, BLANK () )
Step 3) Apply each filter measure to its corresponding table visualOn Table 1: Filters on this visual → drag Is Month 1 → set to is 1. On Table 2: Filters on this visual → drag Is Month 2 → set to is 1. On Table 3: Filters on this visual → drag Is Month 3 → set to is 1.
ryan_mayu
Super User
5 months agoyou need to have a date slicer table and don't create relationship between tables.
then create three measures
Measure =
var _date=max('Table2'[month])
return if(year(max('Table'[Date]))*100+month(max('Table'[Date]))=_date,1)
Measure 2 =
var _date=EDATE(max('Table2'[Date]),1)
var _date2=year(_date)*100+month(_date)
return if(year(max('Table'[Date]))*100+month(max('Table'[Date]))=_date2,1)
Measure 3 =
var _date=EDATE(max('Table2'[Date]),2)
var _date2=year(_date)*100+month(_date)
return if(year(max('Table'[Date]))*100+month(max('Table'[Date]))=_date2,1)
apply each measure to each table and set to 1
pls see the attachment below