Forum Discussion

alsolok's avatar
alsolok
Helper II
5 years ago
Solved

Hierarchy Date

Hello everyone,
I want to create the hierarchy date : Year - Semester - Trimester - Month - Day .

My problem is the column semester and trimester don't accept.

This is my request the create semester and trimester:

semester := QUOTIENT('Dim Calendrier'[Trimestre] + 1, 2)

trimester :=  QUARTER('Dim Calendrier'[Date]).

 

Plz help me 

Need Help
Tips and Tricks
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    Hi alsolok 

     

    You can create each column for date,month,quarter,year and trimeter. Now right click on Year column and create a hierarchy

     

    and now add all your column under this hierarchy

     

    You will get your desired output:-

    Thanks,

    Samarth

     

1 Reply

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    5 years ago

    Hi alsolok 

     

    You can create each column for date,month,quarter,year and trimeter. Now right click on Year column and create a hierarchy

     

    and now add all your column under this hierarchy

     

    You will get your desired output:-

    Thanks,

    Samarth