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
  • hashanr's avatar
    hashanr
    Frequent Visitor
    6 years ago

    amitchandak I wish i could use slicers like your article but user strickly wanted two dropdown slicers to pick periods. Anyway thanks for your attention and support

    • 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 !