Forum Discussion
maurcoll
Helper IV
6 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...
- 6 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.
mickey64
Super User
6 months agoFor your reference.
Step 0: I use these DATA below.
Step 1: I make a 'Calendar' table and add a relationship.
Step 2: I make three measures and a slicer and four tables below.
M_Sum = SUM(DATA[Orders])
M_Sum Month+1 = CALCULATE([M_Sum],DATEADD('Calendar'[Date],1,MONTH))
M_Sum Month+2 = CALCULATE([M_Sum],DATEADD('Calendar'[Date],2,MONTH))