Date range between start end date

[Anonymous]

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.

[amitchandak · Accepted solution]

@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