DAX To calculate current week , next and next to next dynamically

[Anonymous]

Hello Everyone,

I have a requirement where in I have to display the next 2 week data in a table based on the date user select 

say the user select 24-oct-2022 then i should display data from 24 oct 2022 to 4 nov 2022.

Date slicer contains the values in this format .

But I am unable to achieve the required output, Can anyone please help me resolve this issue.

Thanks.

Shubhangi

[v-jianboli-msft]

Hi @Anonymous ,

Based on your description, I have created a simple sample :

Please try:

First, created a date table for slicer:

Then apply the measure to the filter:

Measure = 
var _a = SELECTEDVALUE('Date'[Date])
return IF(MAX('Table'[Date])>=_a&&MAX('Table'[Date])<=_a+13,1,0)

Final otput:

Best Regards,

Jianbo Li

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

[Anonymous]

Hi @v-jianboli-msft 

This seems good, but i want to see 4 weeks data in 4 different table in a single page of the dashboard based on date selected in the slicer.

Please let me know you inputs

[AbbasG]

@Anonymous Hi due tried the relative date slicer? It might solve your problem.