cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
g_l_dixon
Frequent Visitor

Getting prior week measure that will dynamically change with slicer

HI, I don't know if anyone can help me.

 

I'm looking to recreate a table like the below (where 'LM' = last month) but by week. I don't seem to be able to work out how to do it. I'm using a column of 'week commencing', and have tried the below, but it just doesn't work. Any ideas so welcome!! It's all pulling from a spreadsheet. I'm not sure how to upload data for people to see?

 

thanks,

 

Gem

 

LW Income = CALCULATE([Total Single Gift Income],DATESINPERIOD(Sheet1[Week Commencing],MAX(Sheet1[Week Commencing]),-1*7,Day))

 

g_l_dixon_0-1632496419784.png

 

3 REPLIES 3
v-angzheng-msft
Community Support
Community Support

Hi, @g_l_dixon 

 

Do you want to add the week field and calculate the income of the week, or change the measure of calculating the month to the calculation week based on the month field. If it is the latter, how do you determine the date of the week, the last week of the month? Or?
Could you share some dummy data and draw a simple picture to show your expected visual for further discussion?

 

refer:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly

 

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi, I currently have a matrix like this. I want to add in Last week open rate as a measure, last week's CTR as a measure (etc.) I can share data, but there are a lot of measures as well... I'm not sure how to share pbix file but happy to do so? It's all just dummy data for now...

 

g_l_dixon_0-1632752666207.png

 

amitchandak
Super User
Super User

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.