Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date range between start end date

Hi Team, Here am pulling data from azure sql DB(Views) and i don't ave any date table i have only date column  but i want to show in my report on below condition.

Report dates filter should default to NOW+2 and NOW+49.
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Add a measure like this in visual table or all measure should have this filter

     

    calculate(countrows(table), filter(Table, table{date] >=today()+2 && table{date] <=today() +49))

     

    better to use date table

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Add a measure like this in visual table or all measure should have this filter

     

    calculate(countrows(table), filter(Table, table{date] >=today()+2 && table{date] <=today() +49))

     

    better to use date table