Reputation: 447
Is there any way to show the start and end for each week ? or is there any way to make the week start from 1
Upvotes: 1
Views: 59
Reputation: 11896
Try DATETRUNC(‘week’, [Date]}
as a calculated field on the columns shelf. Make sure to treat it as a discrete dimension.
It appears that you are using DATEPART() instead of DATETRUNC()
Upvotes: 2