how should I get current week number?
Ex: my fiscal year starts from July, this is my 31st week. when I am pulling week to report it is giving all weeks 1 to 53. I want to see only this week number =31. to get all fiscal weeks I am using YTD filter.
Thanks in advance.
Can't you use the function _week_of_year ?
Hi,
I am not sure how to use it.
I have fiscal week and fiscal week start date in my model.
Please could you explain me how to use week_of_year function.
when I use it can I see from 1 to 31 weeks data.
Thanks in advance.
Fiscal years that run heavily out of synch with a calender year demand an appropriate date/calender table. This way you will not have to recompute over and over again. Once you have populated the calendertable you can reuse it (using shortcuts in the model) for fiscal calcs..
Is this in a package? Is it a query item?
Fiscal week is a query item
I am not sure if I understand your question, but anyway let me try
Is this a date field like Jan 1, 2009?
You can edit the query item to a week number or you can create an extra query item based on the fiscal date.
For example if you want to convert the fiscal date to week number:
Double click the query subject, select the fiscal date query item, right click, select edit query item and add before the item _week_of_year (, and add the ending ')'.
For example if your query item name is fiscal_date, and your query subject name is fiscal_dim and your source is fiscaldb, it would look like this:
_week_of_year([fiscaldb].[fiscal_dim].[fiscal_date])
this will convert the fiscal date to the week of the year.