Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Using relative date slicer to get last 3 full weeks

Hi,   Hope anyone found a solution to this.   We are trying to set a dynamic period for the last 3 full weeks. In the example to the left this would be a period from 3-9-2018 to 23-9-2018. Th...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi Anonymous,

     

    Based on my test, Using relative date slicer cannot achieve your goal. However we can create a measure to work asourd.

     

    Measure = IF(MAX('Table'[week])=WEEKNUM(TODAY()) || MAX('Table'[week])=WEEKNUM(TODAY()) -1||MAX('Table'[week])=WEEKNUM(TODAY()) -2,1,0)

    Then create a visual and filter the visual by the measure.

     

     

    For more details, please check the pbix as attached.

     

    Regards,

    Frank