Forum Discussion

Kurumi0418's avatar
Kurumi0418
Icon for Helper I rankHelper I
7 years ago

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...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

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

 

 

Kurumi0418's avatar
Kurumi0418
Icon for Helper I rankHelper I
7 years ago

v-juanli-msft

 

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

 

thanks. ^^