Forum Discussion

suvechha's avatar
suvechha
Helper IV
4 years ago
Solved

Exclude the current week ?

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 -

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    4 years ago

    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.

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    4 years ago

    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.