topic Filter table starting from Current Week to 12 more future weeks in DAX Commands and Tips

Filter table starting from Current Week to 12 more future weeks

jiji — Fri, 26 Aug 2022 03:41:05 GMT

Hi Team - Could you please help me how to expose this filter using DAX? I need to show values that always starts in current week Monday to Sunday to 12 more future weeks. I was only able to create "Current week & Next week" as per below:

Column =

VAR next =

TODAY () + 7

VAR yn =

YEAR ( next )

VAR yt =

YEAR ( TODAY () )

VAR weeknumt =

WEEKNUM ( TODAY () )

VAR weeknun =

WEEKNUM ( next )

VAR wek =

WEEKNUM ( 'date'[Date] )

RETURN

IF (

OR (

yn = YEAR ( 'date'[Date] )

&& weeknun = wek,

yt = YEAR ( 'date'[Date] )

&& weeknumt = wek

"current week & next week",

BLANK ()

)

Re: Filter table starting from Current Week to 12 more future weeks

Jihwan_Kim — Fri, 26 Aug 2022 04:09:41 GMT

Hi,

I am not sure how your Dates Table looks like, but I tried to create a sample like the attached.

Please check the below DAX formula for creating a new column and the attached pbix file.

Expected outcome CC = VAR _addweeknumbercol = ADDCOLUMNS ( Dates, "@weeknumber", WEEKNUM ( Dates[Date] ), "@year", YEAR ( Dates[Date] ) ) VAR _futuredate = TODAY () + 84 VAR _weeknumberaftereightyfourdays = MAXX ( FILTER ( _addweeknumbercol, Dates[Date] = _futuredate ), [@weeknumber] ) VAR _yearnumberaftereightyfourdays = MAXX ( FILTER ( _addweeknumbercol, Dates[Date] = _futuredate ), [@year] ) VAR _lastdateaftereightyfourdays = MAXX ( FILTER ( _addweeknumbercol, [@weeknumber] = _weeknumberaftereightyfourdays && [@year] = _yearnumberaftereightyfourdays ), Dates[Date] ) RETURN IF ( Dates[Date] >= TODAY () && Dates[Date] <= _lastdateaftereightyfourdays, "currentWk to 12 more future wks", "Others" )

Re: Filter table starting from Current Week to 12 more future weeks

Anonymous — Tue, 30 Aug 2022 06:50:48 GMT

Hi jiji ,

I have created a simple sample, please refer to it to see if it helps you.

Create a column.

Column = VAR _weeknum = WEEKNUM ( 'date'[Date], 1 ) VAR _weeknumtoday = WEEKNUM ( TODAY (), 1 ) RETURN IF ( _weeknum >= _weeknumtoday && _weeknum <= _weeknumtoday + 12, "currentWk to 12 more future wks", BLANK () )

Then you can filter the column is not blank.

If I have misunderstood your meaning, please provide more details with your desired output and your pbix file without privacy information.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.