Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

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.
8 REPLIES 8
v-binbinyu-msft
Community Support
Community Support

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
Not applicable

data has been provided below.

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
Super User
Super User

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
Not applicable

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.

 

WhenStaffproject id
   
12/10/2012a12
12/10/2012a10
12/10/2012a9
12/10/2012b12
13/10/2012a9
13/10/2012a8
13/10/2012b10
13/10/2012b18
13/10/2012c9
14/10/2012a10
15/10/2012b10
16/10/2012a12
17/10/2012a12
18/10/2012a8
19/10/2012a10
20/10/2012a9
21/10/2012a8
22/10/2012c10
22/10/2012c8
22/10/2012b12
22/10/2012b10

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

Anonymous
Not applicable

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
Not applicable

i have just calculated  from  when 

Weeknumber = WEEKNUM([WHEN],2)

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors