Forum Discussion
Looking at future orders based on date selection
- 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.
Hi maurcoll ,
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank mickey64 , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Best Regards,
Community Support Team
- v-menakakota6 months ago
Community Support
Hi maurcoll ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Best Regards,
Community Support Team