Current Week vs Last Week - Weekly Reporting Requirements

[snaseem]

Hi,

I have a dateset in the below format in excel sheet and I have to go through every week to make changes for weekly and monthly report. All I want is to compare this week changes/status update and last week.

Below is the desired output I need for weekly reporting based on above dataset.

Thanks for your help!

[Anonymous]

Hi  @snaseem ,

I created some data:

Here are the steps you can follow：

1. Create calculated column.

Week =
WEEKNUM('Table'[Date],2)

2. Create measure.

Current Update =
var _today=
TODAY()
var _current=
SUMX(FILTER(ALL('Table'),
'Table'[Project]=MAX('Table'[Project])&&'Table'[Location]=MAX('Table'[Location])&&'Table'[Week]=WEEKNUM(_today,2)),[Value])
return
_current - [Previous Week Update]

Previous Week Update =
var _today=
TODAY()
return
SUMX(FILTER(ALL('Table'),
'Table'[Project]=MAX('Table'[Project])&&'Table'[Location]=MAX('Table'[Location])&&'Table'[Week]=WEEKNUM(_today,2)-1),[Value])

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[snaseem]

Thanks for this.

I want to display the notes or comments column instead of the sum of those numbers.

Any idea how can i achieve this? I assume sumx will not be a solution for this, right?

Looking forward.

[amitchandak]

@snaseem , check if this approach can help

Power BI — Week on Week and WTD
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...
https://www.youtube.com/watch?v=pnAesWxYgJ8

Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

or offset can help

Power BI Offset Compare Categories, Time Intelligence MOM, QOQ, and YOY: https://youtu.be/5YMlkDNGr0U