Create a table of future dates of coming 4 Monday from selected range of end date in the slicer

[Anonymous]

I have a date slicer where user has the option to select date range

so end date would be may 8th 2023,Now i want the projection/future weeks [Only monday dates] for 4 weeks in a table visual w.r.t measure values.

eg:

Projection Dates	Values
15-May-23	208
22-May-23	343
29-May-23	some number
5-Jun-23	some number

Please help on this.

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You need to have a second date table in the model for the future dates. Then create the following measure as a flag to filter the dates from the second date table. 

Flag = 
VAR vDate = SELECTEDVALUE('DateTable'[Date])
RETURN
IF(WEEKDAY(vDate,2)=1 && vDate > MAX('Date'[Date]) && vDate < MAX('Date'[Date])+29 , 1, 0)

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.