Exclude the current week ?

[suvechha]

Hi there ,

I want to show the chart like below -

Last 4 weeks chart -

How to achieve this, which will exclude the current week 47 ?

My Master Calendar - 

Date Range Filter = IF(AND

            (MasterCalendar[Date] > TODAY() -30, MasterCalendar[Date]<TODAY())

            --------------------------------------------------------

            , 1 , 0)

So its taking Week 47 ... How can I exlude the current week ?

My Lastest chart is showing like below -

[ryan_mayu · Accepted solution]

@suvechha 

maybe you can try to create a column to get the current week.

Column = 
VAR _maxyear=max('Table'[year])
VAR _maxweek=maxx(FILTER('Table','Table'[year]=_maxyear),'Table'[week])
return if('Table'[year]=_maxyear&&'Table'[week]=_maxweek,"current week")

then add the new column in the filter, and unselect current week.