Sado
Sado

Reputation: 447

Show Week Dates (Start and End) Instead of Week Number

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 Here is a screenshot of my problem

Upvotes: 1

Views: 59

Answers (1)

Alex Blakemore
Alex Blakemore

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

Related Questions