Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Detailed Week Number #37

Open
ThimiosSp opened this issue Apr 26, 2020 · 1 comment
Open

Add Detailed Week Number #37

ThimiosSp opened this issue Apr 26, 2020 · 1 comment

Comments

@ThimiosSp
Copy link

I use the Template all over my models but I would greatly appreciate a Detailed Week Number in format 'W17 - 20/04/20-26/04/20' to use in slicers.
I have added a column for that already, but would be great to have this embedded.

@weigh2tall
Copy link

I added the following to my calendar table. It worked for our case.

At Line 774
"Calendar Week Start Label", CalendarGregorianPrefix & "W" & FORMAT ( CalWeekNumber, "00" ) & "-" & CalDate - WEEKDAY(CalDate, FirstDayOfWeek +1 )+1,
At Line 1412
"Calendar WeekLabel", [Calendar Week Start Label],

Produces a value "W26-6/22/2020" for example. I think this could handle if you had your calendar setup to start on a day other than Monday because it's leveraging "FirstDayOfWeek" from the variable setup.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants