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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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

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.

Anonymous
Not applicable

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.