Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Future Date Filtering

Hi,   Im looking for some help with creating a filter to apply to my report. I have a field called DUEDATE and i want to filter my report results to show only where the DUEDATE is in the next 3-...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi Anonymous ,

    As my previous note in the formula, you can use today() function to replace the specific date in the formula:

    Measure = 
IF (
    SELECTEDVALUE ( 'Table'[Date] ) >= EDATE ( TODAY(), 3 )
        && SELECTEDVALUE ( 'Table'[Date] ) <= EDATE ( TODAY(), 6 ),
    1,
    0
)

    Result:

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try like

measure =
var _max1 = maxx(allselected(Date),Date[Date])
var _max = date(year(_max1), month(_max1)+6, day(_max1))
var _min = date(year(_max1), month(_max1)+3, day(_max1))
return
calculate([Measure],filter(Date, Date[Date] >=_min && Date[Date] <=_max))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi amitchandak ,

 

Thanks for your reply.

 

I was recieving errors below where its highlighted in bold:-

 

measure =
var _max1 = maxx(allselected(Date),DUEDATE[DATE],
var _max = date(year(_max1), month(_max1)+6, day(_max1))
var _min = date(year(_max1), month(_max1)+3, day(_max1))
return
calculate([Measure],filter(Date, Date[Date] >=_min && Date[Date] <=_max))