Forum Discussion

hashanr's avatar
hashanr
Frequent Visitor
6 years ago

Use two Drop down slicers as FROM /TO filter dates

Hello everyone,   I have this requiremnet where there is two dropdown slicers used to select from/to period. These drop down contains period in [Month] [Year] format and not in proper date format. ...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

hashanr , you may have created two independent date/month tables and choose a month from those as from and 2 and create a measure like 

Measure = 
var _min =maxx(ALLSELECTED('Date1'),'Date1'[Date])
var _max =maxx(ALLSELECTED('Date2'),'Date1'[Date])
return
CALCULATE(SUM('order'[Qty]),filter(all('Date'),'Date'[Date]>=_min && 'Date'[Date]<=_max))

 

 

hashanr's avatar
hashanr
Frequent Visitor
6 years ago

Hi Thank you for your input. I got answers with similar solution from few of members. All considered, I managed to overcome challange. thank you for your support !

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, could you please share how it got resolved. Would be helpful. Looking for similar solution.