Filter by last ten weeks

[RKGV]

Hi Experts

I have a set of data in that I have column with dates in date format (every week Monday) and also week column in YYYYWW format. I want to filter only the last 10 weeks from current day.

Could you please help me on this ?

Thanks in advance

regards,

Rajesh 

[binuacs]

@RKGV can you provide some sample data ?

[RKGV]

attached

[binuacs]

   @RKGV 

[OllieClarke · Accepted solution]

Hi @RKGV 

The following filter should work:

datetimediff(
datetimeadd(datetimetoday(),
(tonumber(datetimeformat(datetimetoday(),'%u'))-1),'day')
,[Date],'day')<=70

Or you can break it out into columns to make it easier

Hope that helps,

Ollie

[RKGV]

Thanks everyone for the help