Forum Discussion

firstch's avatar
firstch
Icon for Helper III rankHelper III
4 years ago
Solved

How to get date between from range filter for smart narrative?

Hi all , how can i get date between from this range filter 

also , how to calculate max and min base on selected  this range filter?

thank you in advance

 

Best Regard 

firstch

  • amitchandak's avatar
    amitchandak
    4 years ago

    firstch , Try in a measure

     

    new measure =
    var _max = maxx(allselected(slicer),slicer[value])
    var _min = minx(allselected(slicer),slicer[value])
    return

    <Your code>

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    firstch , Try in a measure

     

    new measure =
    var _max = maxx(allselected(slicer),slicer[value])
    var _min = minx(allselected(slicer),slicer[value])
    return

    <Your code>

    • firstch's avatar
      firstch
      Icon for Helper III rankHelper III
      4 years ago

      Hi amitchandak 
      now i have 2 measure that is minyear ,maxyear can , how can i calculate max value base on my selected range filter above .

      best regard 
      firstch

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi firstch,

     

    May I know whether your problem has been resolved? If you still have problem, could you please provide some sample data from you slicer field table and date table and make your needs more clear? Thanks in advance!

     

    Best Regards,

    Community Support Team _ Caiyun