Forum Discussion
drilling and date aggregation
I have customer sales data in a matrix with time in the columns. My data is correct in the year view, with two columns, one for 2018 and one for 2019. When I drill in quarters, I only get 4 columns, Q1, Q2, Q3, Q4 instead of the 8 I would like 1Q18, 2Q18, 3Q18, 4Q18, 1Q19, 2Q19, 3Q19, 4Q19. Thanks in advance.
Anonymous so there are two options for drilldown, are you doing drill down using fork kind of symbol for drill down, that is expand one level in the hiearchy
6 Replies
- parry2k
Super User
Anonymous can you explain what you mean by drill? Are you drilling to the other page or it is a matrix or what? If possible share some screen shot.
- parry2k
Anonymous you need to add another column in your model to break quarter column, add new column in calendar table like this and use this column for your drill down.
Quarter with year = Quarter with Year = FORMAT( 'Table'[Date], "Q" & """Q""" & "yy" )