Forum Discussion

Noak's avatar
Noak
Helper IV
9 years ago
Solved

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 ...
  • Noak's avatar
    Noak
    9 years ago

    Hi,

    here's a quickest  solution - calculated column

    Year-Quarter = CONCATENATE( [createdon].[Year]," " & [createdon].[Quarter])

     

    thank you for your help.