Forum Discussion
Calculate Loss from various dates
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
3 Replies
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-Forum/ba-p/963216
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/1447523Column1 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 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
