How to use DAX calu weekly list???

Hi Kurumi0418

Today is 2019/1/30

then 

This week (7days)   2019/1/27-2019/2/2

Last week (7days)   2019/1/20-2019/1/26

Last 2 week (7days) 2019/1/13-2019/1/26

 

Right?

 

Do you want a visual like a line chart where weekday (monday~sunday) in the "X-axix", values in the "Y-axix", "this week/last week/last 2 weeks" in the Legend field?

 

Best Regards

Maggie

 

 

Hi Kurumi0418

Does this help?

 

create a date table

date =
ADDCOLUMNS (
    CALENDARAUTO (),
    "year", YEAR ( [Date] ),
    "month", MONTH ( [Date] ),
    "weeknum", WEEKNUM ( [Date], 1 ),
    "weekday", WEEKDAY ( [Date], 2 )
)

connect this date table to your data table

 

create measures in your data table

this week = IF(YEAR([today])=MAX('date'[year])&&WEEKNUM([today],1)=MAX('date'[weeknum]),1,0)

last week = IF(YEAR([today])=MAX('date'[year])&&WEEKNUM([today],1)=MAX('date'[weeknum])+1,1,0)

last 2 week = IF(YEAR([today])=MAX('date'[year])&&WEEKNUM([today],1)=MAX('date'[weeknum])+2,1,0)

This_week = CALCULATE(SUM(Sheet1[value]),FILTER(Sheet1,[this week]=1))

Last_week = CALCULATE(SUM(Sheet1[value]),FILTER(Sheet1,[last week]=1))

Last2_week = CALCULATE(SUM(Sheet1[value]),FILTER(Sheet1,[last 2 week]=1))

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.