Get last 6 weeks and next 6 weeks data from current date

Praj — Tue, 07 Mar 2023 12:55:53 GMT

Hello Everyone,

I have a huge dataset in a table "Raw" and I am looking create a new table which gives me the data from last 6 weeks and next 6 weeks from current day.

I did write the below code but I am just getting partial rows and not the entire output I am expecting. Can anyone suggest the most efficient approach for this problem.

Last 6 Weeks and Next 6 Weeks = VAR CurrentDate = TODAY() VAR MinDate = MIN(Raw_Salesforce[Close_Date]) VAR MaxDate = MAX(Raw_Salesforce[Close_Date]) RETURN FILTER( 'Raw_Salesforce', Raw_Salesforce[Close_Date] >= DATEADD(Raw_Salesforce[Close_Date], -42, DAY) && Raw_Salesforce[Close_Date] <= DATEADD(Raw_Salesforce[Close_Date], 42, DAY) && Raw_Salesforce[Close_Date] >= IF(CurrentDate > MaxDate, MaxDate, CurrentDate) - 42 && Raw_Salesforce[Close_Date] <= IF(CurrentDate < MinDate, MinDate, CurrentDate) + 42 )

Thanks in advance!

Cheers,

Praj

Re: Get last 6 weeks and next 6 weeks data from current date

FreemanZ — Tue, 07 Mar 2023 13:16:53 GMT

hi Praj

try like:

Last 6 Weeks and Next 6 Weeks =

FILTER(

Raw_Salesforce,

Raw_Salesforce[Close_Date]>=TODAY()-42

&&Raw_Salesforce[Close_Date]<=TODAY()+42

)

topic Get last 6 weeks and next 6 weeks data from current date in DAX Commands and Tips

Get last 6 weeks and next 6 weeks data from current date

Re: Get last 6 weeks and next 6 weeks data from current date