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 ...
General Comment
Need Help
Tips and Tricks
  • 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.

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

Forgot to mention that you can make this dynamic by having your date table reference the earliest and latest dates in your "CreatedOn" field so that the date table always gives you the necessary range.  If you need the range to extend further, than you can either hard code it or use the latest date and add to it, depending on your use case.

 

As for the date hierarchy mixing dates, please provide some additional info so we can discover what is going on.

Noak's avatar
Noak
Helper IV
9 years ago

Hi,

here's a quickest  solution - calculated column

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

 

thank you for your help.