No date hierarchy after group by.

[Anonymous]

After I do a group by and a table generated by group by my date column no has a hierarchy.

LA_Grouped = GROUPBY(LA_Shifts_Grouped, LA_Shifts_Grouped[Driver], LA_Shifts_Grouped[Date], "Moves", MAXX(CURRENTGROUP(),LA_Shifts_Grouped[Moves]))

LA_Shifts_Grouped = GROUPBY('LA Shifts','LA Shifts'[Driver #],'LA Shifts'[Date],'LA Shifts'[Shift],"Moves",COUNTAX(CURRENTGROUP(), 'LA Shifts'[Driver #]))

[v-yingjl · Accepted solution]

Hi @Anonymous ,

If your table which is used in the GROUPBY() function has any relationship with any others tables in the report, the new table will not have the date hierarchy.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous ,These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045

You can create a custom hierarchy if needed

https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

[AllisonKennedy]

@dyakoubek The built-in date hierarchy also disappears with relationships, but I always turn it off for my reports and use my own date table. It gives you more flexibility to create your own custom hierarchies exactly as you want.

Do you have a dating board? https://excelwithallison.blogspot.com/2020/04/dimdate-what-why-and-how.html

Here's how to create your own hierarchy: https://www.youtube.com/watch?v=1Y0T_KkeWyQ