Forum Discussion

Razorbx13's avatar
Razorbx13
Icon for Post Patron rankPost Patron
5 years ago
Solved

Setting a specific date filter whenever a Report is Run

I need to be able to run an report at anytime and run it with dates from the 18th of the previous month to the 19th the current month.  So if I run it on the 28th of September it would auto filter th...
Need Help
  • Razorbx13's avatar
    Razorbx13
    5 years ago

    Had to make a few changes but this got me in the right direction.  It works!  Thank you!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Razorbx13 , You can have a column like

and use this This period as filter on report

new column =
var _day = day(today())
var _min = if(_day <20 , date(year(today()), month(today())-1,19) ,date(year(today()), month(today()),19))
var _max = if(_day <20 , date(year(today()), month(today())-2,18) ,date(year(today()), month(today())-1,18))

return
Switch( True ()
[date] >=_min && [Date] <_max , "This period",
"Others"
)

 

or a measure like

 

new measure =
var _day = day(today())
var _min = if(_day <20 , date(year(today()), month(today())-1,19) ,date(year(today()), month(today()),19))
var _max = if(_day <20 , date(year(today()), month(today())-2,18) ,date(year(today()), month(today())-1,18))

return
calculate([measure], filter(Table, Table[Date] <=_max and Table[Date] >=_min))

  • Razorbx13's avatar
    Razorbx13
    Icon for Post Patron rankPost Patron
    5 years ago

    Had to make a few changes but this got me in the right direction.  It works!  Thank you!