Currently in my project we are using a flip option for Yearly/Quarterly/Monthly now I need to add weekly option to it.
So can Some one tell me how to give weekly data.
Also I have an another requirement, I need to capture weekly comparison i.e Previous week with current week my week starts from mon-fri.
So every friday i need to store the data as previous weeK(Static) and from monday it will be current week(Dynamic).
Thank you in advance.
Try like this.
LOAD *, WeekName(Date) as WeekName,'Q' &Ceil(month(Date)/3)&' '&Year(Date) as Quarter,Month(Date) as Month,Year(Date) as Year;
(ooxml, embedded labels, table is [Sales Data]);
Previous Week (including errors):
Current Week (including errors):
Aplogies for delay in response.
It is working fine, but only issue is, it is comparing with exact previous week(Week -1) .
What if the data is loaded 2 weeks back and not loaded currently i.e we didn't loaded last week and current week also.
With current formula I can't get any information for such situation.
Kindly help me out.