cancel
Showing results for
Did you mean:
Regular Visitor

## How to use DAX calu weekly list???

Hi everyone,

How to use DAX Calu weekly list as blow :

1. This week (7days)

2. Last week (7days)

3. Last 2 week (7days)

I want to show trend chart comparise Weekly status.

Thanks.

4 REPLIES 4
Community Support Team

## Re: How to use DAX calu weekly list???

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

Regular Visitor

## Re: How to use DAX calu weekly list???

@v-juanli-msft

Right, I want this approach. please to share with me.

thanks. ^^

Community Support Team

## Re: How to use DAX calu weekly list???

Does this help?

create a date table

```date =
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.

Highlighted
Regular Visitor

## Re: How to use DAX calu weekly list???

@v-juanli-msft

Hello. I'm try it, but it's can't work on my report.

I want to set weeknum automatic as blow, for now, it's manual, I need manual set it each sunday.

thus, I hope you can teach me a good approach.

Thanks.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 82 members 1,123 guests
Recent signins: