Tish Fernandes Member asked a question. I have three individual fields that are discrete integers in my dimensions. These actually infact dates: Year, Month, Week. That is how my data is and little to nothing I can do anything about it. Also to note, the calendar is a β not sure if that changes anything.
I want to show sales by month and week and use a date slider to filter. Is that possible and any help? You can replace the year, month and date values shown above with your integer fields. How will I include week with dateparse?
I need to be able to drill into month, week - weekly sales. Replace the first highlighted value with the week number. Second and third highlighted values with your year and month numbers. Did not work. The calculation says it is valid but returning nulls. Also, the hierarchy did not drill to 'week', after month-it goes to the day. Insterad of date parsing can I use make date?
I ask this because, I see we are converting int to string, and parsing it to date. This may be performance wise bad right? Instead can we use the int fields to make the date? Also in your formula, why are we subtracting 1 from the dateadd interval declaration? I need to be able to drill to the level of the week - I have Year, month, week as int fields.
I can use 01 for day if needed. Then you can either use a regular join or cross database join to join this to your data and generate an accurate result. There are ways with calculations but this is quite a bit faster to build and easier to maintain. My usual workaround for this case is one of the following:. This runs into the problem that the axis format does not change with the change in parameter. A workaround for that is to not display the axis and instead use some combination of tooltips, mark labels, reference lines, etc.
