Forum Discussion
weekly date breakdown.
This is the DAX i used for week break down but its Blank.
Week Date Range =
VAR StartDate = MIN('Date'[Date])
VAR EndDate = TODAY()
VAR Weeks = WEEKNUM(EndDate) - WEEKNUM(StartDate) + 1
RETURN
GENERATESERIES(
StartDate - WEEKDAY(StartDate, 2) + 1,
StartDate -WEEKDAY(StartDate, 2) + (Weeks * 7),
7
)
I also tried this DAX
Wek Breakdown =
FORMAT(DATEADD('Date'[Date], -WEEKDAY('Date'[Date], 1), DAY), "MM/dd")
& " - " &
FORMAT(DATEADD('Date'[Date], 7 - WEEKDAY('Date'[Date], 1), DAY), "MM/dd").
This sorts of gives me what i want but it is not including today's date.
If i try to include this week 04/01 -today's date, it shows me 12/29
If i try to include this week 04/01 -today's date, it shows me 12/29