Is it possible to attach some sample data and along with desired result,
You can take superstore and provide sample desired O/P how you are expecting so that it will be easy to decipher the issue
Attached the Sample store data and in the sheet 2 , u can see how i want my tabulation.
I want to show the weeknumbers and the sales value along with the days.Here i want to know one thing. week 1 to week 52 is for a full year.I want to show my data from say August2017 till date.Is there a possibility that i can start my week from week 1 to week 4 only for August2018.
If yes please reply m using this formula to get my weeks
ROUND((DATEADD('day', 3, DATETRUNC('week',[Date]))-
DATEADD('day', 3, DATETRUNC('year', DATEADD('day', 3, DATETRUNC('week',[Date])))) +
DATEPART('weekday', DATEADD('day', 2, DATETRUNC('year', DATETRUNC('week',[Date]))))
-4) / 7 + 1,0)
1 of 1 people found this helpful
Yes. I understand this situation. Every month you want show your week as 1,2,3,4 etc with dynamic
if MONTH([Date])=month(today()) then
DATEPART('week',[Date]) - DATEPART('week',DATETRUNC('month',[Date]))+1