Hi,
I'm trying to create a Excel DAX calculated column for the dates next week only.
This works for THIS week only.
=if( year(dCalendar[wtd])=year(today())&&weeknum(dCalendar[wtd])=WEEKNUM(today()-1)&& (dCalendar[wtd])<=TODAY()-1 ,"CURRENT WEEK","OTHER")
But this doesn't for next week.
=if( year(dCalendar[wtd])=year(today())&&weeknum(dCalendar[wtd])>WEEKNUM(today()-1)&& (dCalendar[wtd])>TODAY()-1&& (dCalendar[wtd])<TODAY()+12 ,"NEXT WEEK","OTHER")
I'm trying to create a Excel DAX calculated column for the dates next week only.
This works for THIS week only.
=if( year(dCalendar[wtd])=year(today())&&weeknum(dCalendar[wtd])=WEEKNUM(today()-1)&& (dCalendar[wtd])<=TODAY()-1 ,"CURRENT WEEK","OTHER")
But this doesn't for next week.
=if( year(dCalendar[wtd])=year(today())&&weeknum(dCalendar[wtd])>WEEKNUM(today()-1)&& (dCalendar[wtd])>TODAY()-1&& (dCalendar[wtd])<TODAY()+12 ,"NEXT WEEK","OTHER")