No of updates by clientname in the prior week vs the week before

[Anonymous]

i just cant figure out how to calculate that.

i have update date as date in  data,tried calculating 

Week Start Date = P[updatedate]+-Weekday(P[update_date],2)+3

 how i'm going to go further.

[Anonymous]

Hi @Anonymous ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting and desensitized example data.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[Anonymous]

data has been provided below.

[Anonymous]

HI @Anonymous ,

I'm a little confused about your needs, Could you please explain them further? It would be good to provide a screenshot of the results you are expecting.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Anonymous]

Hi,

This is my sample data , i have project id that connects to main fact table and date of update is when and staff name (who has updated it ). 

now i need to plot No of updates made by staff in the prior week vs the week before..as refrence to todays date.

When	Staff	project id
12/10/2012	a	12
12/10/2012	a	10
12/10/2012	a	9
12/10/2012	b	12
13/10/2012	a	9
13/10/2012	a	8
13/10/2012	b	10
13/10/2012	b	18
13/10/2012	c	9
14/10/2012	a	10
15/10/2012	b	10
16/10/2012	a	12
17/10/2012	a	12
18/10/2012	a	8
19/10/2012	a	10
20/10/2012	a	9
21/10/2012	a	8
22/10/2012	c	10
22/10/2012	c	8
22/10/2012	b	12
22/10/2012	b	10

[lbendlin]

I don't see any mention of weeks in your sample data. Please provide that information.

[Anonymous]

i have tried Cw 

cw = IF(PORT_UPDATES[Weeknumber] = WEEKNUM(TODAY(),12), "Current")

Lw=

Lw = IF(PORT_UPDATES[Weeknumber] = WEEKNUM(TODAY(),12)-1, "Last Week", CONVERT(PORT_UPDATES[Weeknumber],STRING))

but now i have  Cw and Lw in column but i have to plot in graph or table .My ultimate  requirement is  by staff , count(projectid)  for current week and last week.

[Anonymous]

i have just calculated  from  when 

Weeknumber = WEEKNUM([WHEN],2)