Start of Last Week - End of Last = Week data

[paulfink]

hi all,

i am trying to calculate a change in progress for my report using "Start of Last week" with "End of Last Week".

Start = 1000

End = 1500

The difference is 500 (40%)

How can i do this?

I used this post but all my data came up as 0

https://community.powerbi.com/t5/Desktop/Week-over-Week-Comparison/td-p/298471

Same premise just different date period that I want my data to show.

[Fowmy]

@paulfink 


Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?

_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[paulfink]

The desired output is already in my post.

The data I have now is set up as a monthly change so I am not sure how it would be helpful.

Best i can explain it is that we have projects that have progress, we are taking last months progress to this months progress and subtracting to find out the change to see what projects have progressed or have not.

[amitchandak · Accepted solution]

@paulfink , refer my blog , how to do it using week rank

https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...

week of your choice -https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...