Forum Discussion
Noak
9 years agoHelper IV
Date Hierarchy issues
Hello, I'm working on a big report including dates from 2016 and 2017, for some reason the date hirrarchy mixes dates from Q1 2016 and 2017. I would like to present 5 Quarters, Q1 2016 Q2 2016 Q3 ...
- 9 years ago
Hi,
here's a quickest solution - calculated column
Year-Quarter = CONCATENATE( [createdon].[Year]," " & [createdon].[Quarter])
thank you for your help.