Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filtering Date + 7 Days

Hi,   I was wondering if there was a way to create a column or filter so that if you select a specific date, it shows that given date plus a week, or 7 days for the rest of the year/given years. S...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Please check the measure below and see if the result achieve your expectation.

    Measure = 
var sv = SELECTEDVALUE('CALENDAR'[Date])
return 
IF(MAX('Table'[Date])<sv,BLANK(),IF(MOD(DATEDIFF(sv,MAX('Table'[Date]),DAY),7)=0,MAX('Table'[Date])))

     

    BTW, Pbix as attached, hopefully works for you.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Please check the measure below and see if the result achieve your expectation.

Measure = 
var sv = SELECTEDVALUE('CALENDAR'[Date])
return 
IF(MAX('Table'[Date])<sv,BLANK(),IF(MOD(DATEDIFF(sv,MAX('Table'[Date]),DAY),7)=0,MAX('Table'[Date])))

 

BTW, Pbix as attached, hopefully works for you.

 

Best Regards,

Jay

Community Support Team _ Jay Wang

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amazing thank you so much!
Sarah