Dates in Power Bi - Next 4 weeks etc

P0W3RB1

You could follow these steps

1. Create   a measure called CurrentYear = Year(Today()) .  This is to find the year we are in.

2. Create a measure called CurrentWeekNumber = = Weeknum(Today(),2). This assumes the week begins on Monday. 

3. Compute the StartDate for  4 weeks from CurrentWeekNumber

     StartDate = Date([CurrentYear],1,-3) - Weekday(Date([CurrentYear],1,2))+([CurWeekNum]+4) * 7

4. Compute the EndDate of the 4 weeks from now,

       EndDate = [StartDate]+6

5. Now you need to create a Date Table  using the expression

         DateTable = CALENDAR (ToDay(), [EndDate])

        This will create a DateTable with Date column containing values from TOday upto end of 4 weeks from now.

         This will create the column Date in the table automatically.  Remember to set the format for this column in                          dd/mm/yyyy format or the date format you use.

6.  Create a column called Weeknum in the Date Table using 

       WeekNum = Weeknum(DateTable[Date],2) 

7.   Now Create a Slicer showing the Date column from the Date Table.

8.  You should now be able to the dates in the next 4 weeks including current date.

Hope this explains.  

If you need further reply to this.

For explanation on the formuals used to compute the dates you may refer

https://www.ablebits.com/office-addins-blog/2015/04/29/excel-weeknum-function-convert-week-number-date/

If you find this working please accept as solution and mark as kudos.

Best