Calculate Loss from various dates

[Gurpreet86]

Hi guys, I have a quick question. I want to calculate losses for 10 different stores from the date when they refurbished (all in last 12 weeks on different dates). 
I have Total loss figure for every stores (on weekly basis) but problem is I have these figures from start of financial year. However, I want to calculate from the date store reopened after refurbishments. 

So far, I have used WEEKNUM column to specify the week numbers. 

my aim is to compare losses per week with same period last year 

[Anonymous]

Hi @Gurpreet86 ,

Could you please provide a description of the data model and visualization method to further elaborate on your requirements? This will help us provide better assistance.

Regarding your request to compare store losses by week, I suggest using a Matrix visual object, with store names and weeks as rows and years as columns, to achieve a similar effect as shown in the diagram below.

Best Regards,
Bof

[Preetsingh86]

Column1	Store Number	Status	Completion Date
Project	190	Approved	27/09/24
Project	259	Approved	27/09/24
Project	262	Approved	22/08/24
Project	301	Approved	11/10/24
Project	577	Approved	24/08/24
Project	602	Approved	01/11/24
Project	633	Approved	09/08/24
Project	633	Approved	August
Project	644	Approved	31/08/24
Project	836	Approved	23/08/24
Project	849	Approved	08/11/24
Project	917	Approved	04/10/24
Project	970	Approved	26/09/24
Project	1000	Approved	25/10/24
Project	1060	Approved	18/10/24
Project	1191	Approved	01/09/24
Project	1200	Approved	18/11/24

[lbendlin]

Weeks and years and "same period last year" are not compatible. Best you can do is subtract 364.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...